查询以从数据库中查找外键和主键 [英] query for finding foreign key and primary key from database

问题描述

您好如何使用查询从数据库中查找外键和主键

在sql server 2005中?

说出从数据库中查找外键和主键的查询.
任何人都知道答案更新..

Hi how to find the foreign key and primary key from a database using query

in sql server 2005?

say the query for finding foreign key and primary key from database.
Anybody know the answer update..

推荐答案

看看

选中此选项.

Check this.

Retrieve List of Primary Keys and Foreign Keys of Database[^]

执行以下查询可从数据库中找到主键和外键

Execute this below query to find Primary Keys and Foreign Keys from database

Select * From SysObjects Where xType IN (''PK'', ''F'')

这篇关于查询以从数据库中查找外键和主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！