Friday, 28 March 2014

Find out the Foreign Key column name ,table name & references table, column names?

SELECT 
    F.NAME AS FOREIGNKEY,
    OBJECT_NAME(F.PARENT_OBJECT_ID) AS TABLENAME,
    COL_NAME(FC.PARENT_OBJECT_ID,
    FC.PARENT_COLUMN_ID) AS COLUMNNAME,
    OBJECT_NAME (F.REFERENCED_OBJECT_ID) AS REFERENCETABLENAME,
    COL_NAME(FC.REFERENCED_OBJECT_ID,
    FC.REFERENCED_COLUMN_ID) AS REFERENCECOLUMNNAME
FROM 
    SYS.FOREIGN_KEYS AS F
    INNER JOIN SYS.FOREIGN_KEY_COLUMNS AS FC ON F.OBJECT_ID = FC.CONSTRAINT_OBJECT_ID
    ORDER BY    COL_NAME(FC.REFERENCED_OBJECT_ID,FC.REFERENCED_COLUMN_ID)

SQLDBA- SQL Server Wait Events

  To solve slowness of SQL Server database, you should find which wait events exists in the database. You can find wait events of database w...