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 : export or download SSIS packages

As part of the SSIS package upgrade planning, we need to ensure that the latest source code for all deployed packages is available in our so...