SQL Server 定义了主键，没有定义名字，如何找到这个主键

先看两个表 

create table customers(
c_id int primary key,
c_name varchar(50) ,
c_contact varchar(50), 
c_city varchar(50),
c_birth datetime 
) 

create table orders(
o_num int primary key,
o_date date,
c_id int,
constraint fk_客户ID foreign key(c_id) references customers(c_id)
)

有三种方法：

1.

SELECT CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE='PRIMARY KEY' AND TABLE_SCHEMA='dbo' AND TABLE_NAME='customers'

 

2. 

select a.Name as 表名,b.Xtype as 键类型,b.Name as 键名
from sysobjects a,sysobjects b
where a.ID=b.parent_obj and a.name='customers'
and b.Xtype in('F','PK')

3. 把原来有主键得那个表查询结果创建成一个表，然后删掉原来那个表 

参考 http://www.voidcn.com/article/p-gfxzohzo-byt.html