找出sql server 2000一个表的主键由哪几个字段组成

Question

select name from syscolumns where id=object_id('table_name')

Answer 1

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='表名'

Answer 2

if object_id('tb')is not null drop table tb
go
create table tb(ID int ,ID1 int primary key(ID,id1),name varchar(10))
go
exec sp_Pkeys tb
/*TABLE_QUALIFIER                                                                                                                  TABLE_OWNER                                                                                                                      TABLE_NAME                                                                                                                       COLUMN_NAME                                                                                                                      KEY_SEQ PK_NAME                                                                                                                          
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------- -------------------------------------------------------------------------------------------------------------------------------- 
db_Study                                                                                                                         dbo                                                                                                                              tb                                                                                                                               ID                                                                                                                               1       PK__tb__66EB10A1
db_Study                                                                                                                         dbo                                                                                                                              tb                                                                                                                               ID1                                                                                                                              2       PK__tb__66EB10A1*/

Answer 3

select name from syscolumns where id=object_id('table_name') and status=16

Answer 4

exec sp_helpindex table_name这个是不是也可以啊？