通过查询我想知道主键和外键 [英] through query i want to know primary key and foreign key

问题描述

如何通过查询知道我在数据库中使用的主键和外键.

How can I know what are the primary and foreign key I have used in my database through query.

推荐答案

^ ]

您要在多大程度上查看详细信息?
无论如何，这是一个解决方案:

To what extent do you want to see the details ?
Anyway here is one solution :

SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc IN ('FOREIGN_KEY_CONSTRAINT','PRIMARY_KEY_CONSTRAINT')

从这里开始:

from here :
http://blog.sqlauthority.com/2009/07/17/sql-server-two-methods-to-retrieve-list-of-primary-keys-and-foreign-keys-of-database/[^]

Hope it helps.

这篇关于通过查询我想知道主键和外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！