blocks|key|184177|text|这就是它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184178|SELECT+
+++OBJECT_NAME(f.parent_object_id)+TableName,
+++COL_NAME(fc.parent_object_id,fc.parent_column_id)+ColName
FROM+
+++sys.foreign_keys+AS+f
INNER+JOIN+
+++sys.foreign_key_columns+AS+fc+
++++++ON+f.OBJECT_ID+=+fc.constraint_object_id
INNER+JOIN+
+++sys.tables+t+
++++++ON+t.OBJECT_ID+=+fc.referenced_object_id
WHERE+
+++OBJECT_NAME+(f.referenced_object_id)+=+'YourTableName'|code-block|syntax|javascript|184179|这样，您将获得引用表和列名。|184180|根据评论建议，编辑为使用sys.tables而不是通用sys.objects。谢谢，marc_s|184181|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Here it is:

<pre><code>SELECT 
 OBJECT_NAME(f.parent_object_id) TableName,
 COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM 
 sys.foreign_keys AS f
INNER JOIN 
 sys.foreign_key_columns AS fc 
 ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN 
 sys.tables t 
 ON t.OBJECT_ID = fc.referenced_object_id
WHERE 
 OBJECT_NAME (f.referenced_object_id) = 'YourTableName'
</code></pre>

This way, you'll get the referencing table and column name.

Edited to use sys.tables instead of generic sys.objects as per comment suggestion.
Thanks, marc_s

blocks|key|2798512|text|另一种方法是检查|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2798513|sp_help+'TableName'|code-block|syntax|javascript|2798514|(或者只突出显示引用的TableName并按ALT%2BF1键)|2798515|随着时间的推移，我决定改进我的答案。下面是sp_help提供的结果的屏幕截图。A在此示例中使用了AdventureWorksDW2012+DB。那里有许多好的信息，我们正在寻找的是在最末端-以绿色突出显示：|offset|length|style|CODE|2798516|​|2798517|📷|atomic|2798518|2798519|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d7781fe998d74d94ab45c206a65f3ea1.png|imageAlt^0|0|0|0|L|7|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|15|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|16|8|@$K|17|L|18|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|19|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1A|8|@]|9|@$K|1B|L|1C|1|1D]]|A|$]]|$1|T|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11|12|-4]]]]

Another way is to check the results of
<pre><code>sp_help 'TableName'
</code></pre>
(or just highlight the quoted TableName and press ALT+F1)
With time passing, I just decided to refine my answer. Below is a screenshot of the results that <code>sp_help</code> provides. A have used the AdventureWorksDW2012 DB for this example. There is numerous good information there, and what we are looking for is at the very end - highlighted in green:
<a href="https://i.stack.imgur.com/HxteO.png" rel="noreferrer"><img src="https://i.stack.imgur.com/HxteO.png" alt="enter image description here" /></a>

blocks|key|181890|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|181891|SELECT
++object_name(parent_object_id)+ParentTableName,
++object_name(referenced_object_id)+RefTableName,
++name+
FROM+sys.foreign_keys
WHERE+parent_object_id+=+object_id('Tablename')|code-block|syntax|javascript|181892|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this

<pre><code>SELECT
 object_name(parent_object_id) ParentTableName,
 object_name(referenced_object_id) RefTableName,
 name 
FROM sys.foreign_keys
WHERE parent_object_id = object_id('Tablename')
</code></pre>

blocks|key|184238|text|我发现这个答案非常简单，并且做了我需要的事情：https://stackoverflow.com/a/12956348/652519|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|184239|链接中的摘要，请使用以下查询：|184240|EXEC+sp_fkeys+'TableName'|code-block|syntax|javascript|184241|快速而简单。我能够非常快速地找到15个表的所有外键表、各自的列和外键名。|184242|正如@mdisibio下面提到的，这里有一个文档链接，详细介绍了可以使用的不同参数：https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-fkeys-transact-sql|184243|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/12956348/652519|1|https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-fkeys-transact-sql^0|N|17|0|0|0|0|0|16|2W|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|13|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]]]

I found this answer quite simple and did the trick for what I needed: <a href="https://stackoverflow.com/a/12956348/652519">https://stackoverflow.com/a/12956348/652519</a>

A summary from the link, use this query:

<pre><code>EXEC sp_fkeys 'TableName'
</code></pre>

Quick and simple. I was able to locate all the foreign key tables, respective columns and foreign key names of 15 tables pretty quickly.

As @mdisibio noted below, here's a link to the documentation that details the different parameters that can be used: <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-fkeys-transact-sql" rel="noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-fkeys-transact-sql</a>

blocks|key|3010846|text|这是在所有数据库中找出外键关系的最好方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3010847|exec+sp_helpconstraint+'Table+Name'|code-block|syntax|javascript|3010848|还有一种方法|3010849|select+*+from+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+where+TABLE_NAME='Table+Name'
--and+left(CONSTRAINT_NAME,2)='FK'(If+you+want+single+key)|3010850|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Here is the best way to find out Foreign Key Relationship in all Database.

<pre><code>exec sp_helpconstraint 'Table Name'
</code></pre>

and one more way

<pre><code>select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME='Table Name'
--and left(CONSTRAINT_NAME,2)='FK'(If you want single key)
</code></pre>

blocks|key|2798578|text|我使用此脚本查找所有与外键相关的详细信息。我使用的是INFORMATION.SCHEMA。下面是一个SQL脚本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2798579|SELECT+
++++ccu.table_name+AS+SourceTable
++++,ccu.constraint_name+AS+SourceConstraint
++++,ccu.column_name+AS+SourceColumn
++++,kcu.table_name+AS+TargetTable
++++,kcu.column_name+AS+TargetColumn
FROM+INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE+ccu
++++INNER+JOIN+INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS+rc
++++++++ON+ccu.CONSTRAINT_NAME+=+rc.CONSTRAINT_NAME+
++++INNER+JOIN+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+kcu+
++++++++ON+kcu.CONSTRAINT_NAME+=+rc.UNIQUE_CONSTRAINT_NAME++
ORDER+BY+ccu.table_name|code-block|syntax|javascript|2798580|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I am using this script to find all details related to foreign key. 
I am using INFORMATION.SCHEMA. 
Below is a SQL Script:

<pre><code>SELECT 
 ccu.table_name AS SourceTable
 ,ccu.constraint_name AS SourceConstraint
 ,ccu.column_name AS SourceColumn
 ,kcu.table_name AS TargetTable
 ,kcu.column_name AS TargetColumn
FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
 ON ccu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME 
 INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu 
 ON kcu.CONSTRAINT_NAME = rc.UNIQUE_CONSTRAINT_NAME 
ORDER BY ccu.table_name
</code></pre>

blocks|key|3010766|text|如果您想通过对象资源管理器窗口上的SSMS，右键单击您想要删除的对象，查看依赖项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3010767|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

if you want to go via SSMS on the object explorer window, right click on the object you want to drop, do view dependencies.

blocks|key|184253|text|SELECT+
++++obj.name++++++AS+FK_NAME,
++++sch.name++++++AS+[schema_name],
++++tab1.name+++++AS+[table],
++++col1.name+++++AS+[column],
++++tab2.name+++++AS+[referenced_table],
++++col2.name+++++AS+[referenced_column]
FROM+
+++++sys.foreign_key_columns+fkc
INNER+JOIN+sys.objects+obj
++++ON+obj.object_id+=+fkc.constraint_object_id
INNER+JOIN+sys.tables+tab1
++++ON+tab1.object_id+=+fkc.parent_object_id
INNER+JOIN+sys.schemas+sch
++++ON+tab1.schema_id+=+sch.schema_id
INNER+JOIN+sys.columns+col1
++++ON+col1.column_id+=+parent_column_id+AND+col1.object_id+=+tab1.object_id
INNER+JOIN+sys.tables+tab2
++++ON+tab2.object_id+=+fkc.referenced_object_id
INNER+JOIN+sys.columns+col2
++++ON+col2.column_id+=+referenced_column_id+
++++++++AND+col2.object_id+=++tab2.object_id;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|184254|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT 
 obj.name AS FK_NAME,
 sch.name AS [schema_name],
 tab1.name AS [table],
 col1.name AS [column],
 tab2.name AS [referenced_table],
 col2.name AS [referenced_column]
FROM 
 sys.foreign_key_columns fkc
INNER JOIN sys.objects obj
 ON obj.object_id = fkc.constraint_object_id
INNER JOIN sys.tables tab1
 ON tab1.object_id = fkc.parent_object_id
INNER JOIN sys.schemas sch
 ON tab1.schema_id = sch.schema_id
INNER JOIN sys.columns col1
 ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_id
INNER JOIN sys.tables tab2
 ON tab2.object_id = fkc.referenced_object_id
INNER JOIN sys.columns col2
 ON col2.column_id = referenced_column_id 
 AND col2.object_id = tab2.object_id;
</code></pre>

blocks|key|186294|text|在SQL+Server+Management+Studio中，只需在对象资源管理器中右键单击该表，然后选择“查看依赖项”即可。这将给你一个很好的起点。它显示引用该表的表、视图和过程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186295|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In SQL Server Management Studio you can just right click the table in the 
object explorer and select "View Dependencies". This would give a you a
good starting point. It shows tables, views, and procedures that reference
the table.

blocks|key|183396|text|--以下内容可能会为您提供更多您正在寻找的内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183397|create+Procedure+spShowRelationShips+
(+
++++@Table+varchar(250)+=+null,
++++@RelatedTable+varchar(250)+=+null
)
as
begin
++++if+@Table+is+null+and+@RelatedTable+is+null
++++++++select++object_name(k.constraint_object_id)+ForeginKeyName,+
++++++++++++++++object_name(k.Parent_Object_id)+TableName,+
++++++++++++++++object_name(k.referenced_object_id)+RelatedTable,+
++++++++++++++++c.Name+RelatedColumnName,++
++++++++++++++++object_name(rc.object_id)+%2B+'.'+%2B+rc.name+RelatedKeyField
++++++++from+sys.foreign_key_columns+k
++++++++left+join+sys.columns+c+on+object_name(c.object_id)+=+object_name(k.Parent_Object_id)+and+c.column_id+=+k.parent_column_id
++++++++left+join+sys.columns+rc+on+object_name(rc.object_id)+=+object_name(k.referenced_object_id)+and+rc.column_id+=+k.referenced_column_id
++++++++order+by+2,3

++++if+@Table+is+not+null+and+@RelatedTable+is+null
++++++++select++object_name(k.constraint_object_id)+ForeginKeyName,+
++++++++++++++++object_name(k.Parent_Object_id)+TableName,+
++++++++++++++++object_name(k.referenced_object_id)+RelatedTable,+
++++++++++++++++c.Name+RelatedColumnName,++
++++++++++++++++object_name(rc.object_id)+%2B+'.'+%2B+rc.name+RelatedKeyField
++++++++from+sys.foreign_key_columns+k
++++++++left+join+sys.columns+c+on+object_name(c.object_id)+=+object_name(k.Parent_Object_id)+and+c.column_id+=+k.parent_column_id
++++++++left+join+sys.columns+rc+on+object_name(rc.object_id)+=+object_name(k.referenced_object_id)+and+rc.column_id+=+k.referenced_column_id
++++++++where+object_name(k.Parent_Object_id)+=@Table
++++++++order+by+2,3

++++if+@Table+is+null+and+@RelatedTable+is+not+null
++++++++select++object_name(k.constraint_object_id)+ForeginKeyName,+
++++++++++++++++object_name(k.Parent_Object_id)+TableName,+
++++++++++++++++object_name(k.referenced_object_id)+RelatedTable,+
++++++++++++++++c.Name+RelatedColumnName,++
++++++++++++++++object_name(rc.object_id)+%2B+'.'+%2B+rc.name+RelatedKeyField
++++++++from+sys.foreign_key_columns+k
++++++++left+join+sys.columns+c+on+object_name(c.object_id)+=+object_name(k.Parent_Object_id)+and+c.column_id+=+k.parent_column_id
++++++++left+join+sys.columns+rc+on+object_name(rc.object_id)+=+object_name(k.referenced_object_id)+and+rc.column_id+=+k.referenced_column_id
++++++++where+object_name(k.referenced_object_id)+=@RelatedTable
++++++++order+by+2,3



end|code-block|syntax|javascript|183398|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

--The following may give you more of what you're looking for:

<pre><code>create Procedure spShowRelationShips 
( 
 @Table varchar(250) = null,
 @RelatedTable varchar(250) = null
)
as
begin
 if @Table is null and @RelatedTable is null
 select object_name(k.constraint_object_id) ForeginKeyName, 
 object_name(k.Parent_Object_id) TableName, 
 object_name(k.referenced_object_id) RelatedTable, 
 c.Name RelatedColumnName, 
 object_name(rc.object_id) + '.' + rc.name RelatedKeyField
 from sys.foreign_key_columns k
 left join sys.columns c on object_name(c.object_id) = object_name(k.Parent_Object_id) and c.column_id = k.parent_column_id
 left join sys.columns rc on object_name(rc.object_id) = object_name(k.referenced_object_id) and rc.column_id = k.referenced_column_id
 order by 2,3

 if @Table is not null and @RelatedTable is null
 select object_name(k.constraint_object_id) ForeginKeyName, 
 object_name(k.Parent_Object_id) TableName, 
 object_name(k.referenced_object_id) RelatedTable, 
 c.Name RelatedColumnName, 
 object_name(rc.object_id) + '.' + rc.name RelatedKeyField
 from sys.foreign_key_columns k
 left join sys.columns c on object_name(c.object_id) = object_name(k.Parent_Object_id) and c.column_id = k.parent_column_id
 left join sys.columns rc on object_name(rc.object_id) = object_name(k.referenced_object_id) and rc.column_id = k.referenced_column_id
 where object_name(k.Parent_Object_id) =@Table
 order by 2,3

 if @Table is null and @RelatedTable is not null
 select object_name(k.constraint_object_id) ForeginKeyName, 
 object_name(k.Parent_Object_id) TableName, 
 object_name(k.referenced_object_id) RelatedTable, 
 c.Name RelatedColumnName, 
 object_name(rc.object_id) + '.' + rc.name RelatedKeyField
 from sys.foreign_key_columns k
 left join sys.columns c on object_name(c.object_id) = object_name(k.Parent_Object_id) and c.column_id = k.parent_column_id
 left join sys.columns rc on object_name(rc.object_id) = object_name(k.referenced_object_id) and rc.column_id = k.referenced_column_id
 where object_name(k.referenced_object_id) =@RelatedTable
 order by 2,3



end
</code></pre>

blocks|key|183434|text|你也可以通过修改@LittleSweetSeas的答案来返回所有关于Foreign+Keys的信息：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|183435|SELECT+
+++OBJECT_NAME(f.parent_object_id)+ConsTable,
+++OBJECT_NAME+(f.referenced_object_id)+refTable,
+++COL_NAME(fc.parent_object_id,fc.parent_column_id)+ColName
FROM+
+++sys.foreign_keys+AS+f
INNER+JOIN+
+++sys.foreign_key_columns+AS+fc+
++++++ON+f.OBJECT_ID+=+fc.constraint_object_id
INNER+JOIN+
+++sys.tables+t+
++++++ON+t.OBJECT_ID+=+fc.referenced_object_id
order+by
ConsTable|code-block|syntax|javascript|183436|entityMap^0|Y|C|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You can also return all the information about the <code>Foreign Keys</code> by adapating @LittleSweetSeas answer:

<pre><code>SELECT 
 OBJECT_NAME(f.parent_object_id) ConsTable,
 OBJECT_NAME (f.referenced_object_id) refTable,
 COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM 
 sys.foreign_keys AS f
INNER JOIN 
 sys.foreign_key_columns AS fc 
 ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN 
 sys.tables t 
 ON t.OBJECT_ID = fc.referenced_object_id
order by
ConsTable
</code></pre>

blocks|key|2798736|text|在对象资源管理器中，展开该表，然后展开键：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2798737|​|2798738|📷|atomic|offset|length|2798739|2798740|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/e39d6233fc3d45c22ebb21030c4cd80d.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

In Object Explorer, expand the table, and expand the Keys:
<a href="https://i.stack.imgur.com/nAYtL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nAYtL.png" alt="enter image description here" /></a>

blocks|key|3010974|text|尝试执行以下查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3010975|select+object_name(sfc.constraint_object_id)+AS+constraint_name,
+++++++OBJECT_Name(parent_object_id)+AS+table_name+,
+++++++ac1.name+as+table_column_name,
+++++++OBJECT_name(referenced_object_id)+as+reference_table_name,++++++
+++++++ac2.name+as+reference_column_name
from++sys.foreign_key_columns+sfc
join+sys.all_columns+ac1+on+(ac1.object_id=sfc.parent_object_id+and+ac1.column_id=sfc.parent_column_id)
join+sys.all_columns+ac2+on+(ac2.object_id=sfc.referenced_object_id+and+ac2.column_id=sfc.referenced_column_id)+
where+sfc.parent_object_id=OBJECT_ID(<main+table+name>);|code-block|syntax|javascript|3010976|这将给出将被引用的constraint_name、column_names和将依赖于约束的表。|3010977|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

try the following query.

<pre><code>select object_name(sfc.constraint_object_id) AS constraint_name,
 OBJECT_Name(parent_object_id) AS table_name ,
 ac1.name as table_column_name,
 OBJECT_name(referenced_object_id) as reference_table_name, 
 ac2.name as reference_column_name
from sys.foreign_key_columns sfc
join sys.all_columns ac1 on (ac1.object_id=sfc.parent_object_id and ac1.column_id=sfc.parent_column_id)
join sys.all_columns ac2 on (ac2.object_id=sfc.referenced_object_id and ac2.column_id=sfc.referenced_column_id) 
where sfc.parent_object_id=OBJECT_ID(&lt;main table name&gt;);
</code></pre>

this will give the constraint_name, column_names which will be referring and tables which will be depending on the constraint will be there.

blocks|key|2798626|text|您可以使用以下查询来显示Foreign+key+constaraints：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2798627|SELECT
K_Table+=+FK.TABLE_NAME,
FK_Column+=+CU.COLUMN_NAME,
PK_Table+=+PK.TABLE_NAME,
PK_Column+=+PT.COLUMN_NAME,
Constraint_Name+=+C.CONSTRAINT_NAME
FROM+INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS+C
INNER+JOIN+INFORMATION_SCHEMA.TABLE_CONSTRAINTS+FK+ON+C.CONSTRAINT_NAME+=+FK.CONSTRAINT_NAME
INNER+JOIN+INFORMATION_SCHEMA.TABLE_CONSTRAINTS+PK+ON+C.UNIQUE_CONSTRAINT_NAME+=+PK.CONSTRAINT_NAME
INNER+JOIN+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+CU+ON+C.CONSTRAINT_NAME+=+CU.CONSTRAINT_NAME
INNER+JOIN+(
SELECT+i1.TABLE_NAME,+i2.COLUMN_NAME
FROM+INFORMATION_SCHEMA.TABLE_CONSTRAINTS+i1
INNER+JOIN+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+i2+ON+i1.CONSTRAINT_NAME+=+i2.CONSTRAINT_NAME
WHERE+i1.CONSTRAINT_TYPE+=+'PRIMARY+KEY'
)+PT+ON+PT.TABLE_NAME+=+PK.TABLE_NAME
----+optional:
ORDER+BY
1,2,3,4
WHERE+PK.TABLE_NAME='YourTable'|code-block|syntax|javascript|2798628|摘自http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/|2798629|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/^0|C|B|0|0|2|44|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

You could use this query to display <code>Foreign key</code> constaraints:

<pre><code>SELECT
K_Table = FK.TABLE_NAME,
FK_Column = CU.COLUMN_NAME,
PK_Table = PK.TABLE_NAME,
PK_Column = PT.COLUMN_NAME,
Constraint_Name = C.CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
SELECT i1.TABLE_NAME, i2.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
) PT ON PT.TABLE_NAME = PK.TABLE_NAME
---- optional:
ORDER BY
1,2,3,4
WHERE PK.TABLE_NAME='YourTable'
</code></pre>

Taken from <a href="http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/" rel="nofollow">http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/</a>

blocks|key|3011039|text|获取表的Primary+Key和Foreign+Key的最简单方法是：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3011040|/*++Get+primary+key+and+foreign+key+for+a+table+*/
USE+DatabaseName;

SELECT+CONSTRAINT_NAME+FROM+INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE+CONSTRAINT_NAME+LIKE+'PK%25'+AND
TABLE_NAME+=+'TableName'

SELECT+CONSTRAINT_NAME+FROM+INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE+CONSTRAINT_NAME+LIKE+'FK%25'+AND
TABLE_NAME+=+'TableName'|code-block|syntax|javascript|3011041|entityMap^0|4|B|G|B|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

The easiest way to get <code>Primary Key</code> and <code>Foreign Key</code> for a table is:

<pre><code>/* Get primary key and foreign key for a table */
USE DatabaseName;

SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE CONSTRAINT_NAME LIKE 'PK%' AND
TABLE_NAME = 'TableName'

SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE CONSTRAINT_NAME LIKE 'FK%' AND
TABLE_NAME = 'TableName'
</code></pre>

blocks|key|182055|text|该过程|type|unstyled|depth|inlineStyleRanges|entityRanges|data|182056|sp_help+'tbl_name‘|182057|确实提供了很多信息，但我发现|182058|sp_fkeys+'tbl_name‘和sp_pkeys+'tbl_name’|182059|更容易使用，而且可能具有更面向未来的结果。|182060|(他们确实很好地回答了这个问题)|182061|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

The procedure
sp_help 'tbl_name'
does give a lot of information but I find the procedures
sp_fkeys 'tbl_name' and
sp_pkeys 'tbl_name'
easier to use, and maybe with a more future-proof result.
(And they do answer the OP perfectly)

I am trying to drop a table but getting the following message:

<blockquote>
 Msg 3726, Level 16, State 1, Line 3 
 Could not drop object 'dbo.UserProfile' because it is referenced by a FOREIGN KEY constraint. 
 Msg 2714, Level 16, State 6, Line 2 
 There is already an object named 'UserProfile' in the database.
</blockquote>

I looked around with SQL Server Management Studio but I am unable to find the constraint. How can I find out the foreign key constraints?

How can I find out what FOREIGN KEY constraint references a table in SQL Server?

SQL Server

数据库

我正在尝试删除一个表，但收到以下消息：消息3726，级别16，状态1，第3行无法删除对象“”dbo.UserProfile“”，因为它被外键约束引用。“”Msg 2714，Level 16，State 6，Line 2数据库中已存在名为'UserProfile‘的对象。我使用SQL Server Management Studio查看了一下，但找不到约束条件。如何找出外键约束？

问如何在SQL Server中找出哪些外键约束引用了表？
EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server中找出哪些外键约束引用了表？EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server中找出哪些外键约束引用了表？
EN