sqlserver 2005 获取表的主键和外键列名

获取所有表名称

select [name] from sysobjects where xType = 'U'

获取指定表中所有的字段名
select [name] from essence.dbo.syscolumns where object_name(id)= '表名'

 

获取表外键

select * from sysforeignkeys

 

 

获取主键，最简便的句子

SELECT *FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='表名'

获取主键，较简便的句子

 

SELECT   name FROM SysColumns WHERE id=Object_Id('表名') and colid in (select keyno from sysindexkeys where id=Object_Id('表名'))