Archive

Archive for October, 2009

Find Tables With Primary Key Constraint

October 27, 2009 Leave a comment

SELECT

i.name AS IndexName
    ,OBJECT_NAME(ic.OBJECT_ID) AS TableName
    , COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i
    INNER JOIN sys.index_columns AS ic ON i.OBJECT_ID = ic.OBJECT_ID AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1

Categories: Database

Find Tables With Foreign Key Constraint

October 27, 2009 Leave a comment

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
where OBJECT_NAME (f.referenced_object_id) =‘table_name’

Categories: Database