TA貢獻1802條經驗 獲得超5個贊
sp_fkeys
EXEC sp_fkeys 'TableName'
EXEC sp_fkeys @pktable_name = 'TableName', @pktable_owner = 'dbo'
如果未指定pktable_Owner，則應用基礎DBMS的默認表可見性規則。
在SQLServer中，如果當前用戶擁有具有指定名稱的表，則返回該表的列。如果未指定pktable_Owner，且當前用戶沒有擁有具有指定pktable_name的表，則該過程將查找數據庫所有者擁有的具有指定pktable_name的表。如果存在，則返回該表的列。
TA貢獻1887條經驗 獲得超5個贊
select t.name as TableWithForeignKey, fk.constraint_column_id as FK_PartNo, c. name as ForeignKeyColumn from sys.foreign_key_columns as fkinner join sys.tables as t on fk.parent_object_id = t.object_idinner join sys.columns as c on fk.parent_object_id = c.object_id and fk.parent_column_id = c.column_idwhere fk.referenced_object_id = (select object_id from sys.tables where name = 'TableOthersForeignKeyInto')order by TableWithForeignKey, FK_PartNo
select distinct name from sys.objects where object_id in ( select fk.constraint_object_id from sys.foreign_key_columns as fk where fk.referenced_object_id = (select object_id from sys.tables where name = 'TableOthersForeignKeyInto'))
舉報