If anyone is interested in how to list columns in the main key on the mssql server then I present a quick script.

SELECT
    Col.Column_Name
    ,Col.Table_Name
    ,OBJECT_ID(Col.Table_Name) AS [object_id]
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab
    ,INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col
WHERE
    Col.Constraint_Name = Tab.Constraint_Name
    AND Col.Table_Name = Tab.Table_Name
    AND Constraint_Type = 'PRIMARY KEY'
    AND [Col].Table_name='<TABLENAME>'

Comments


Comments are closed