摘要:---表中的主鍵select [name],'tablekey'= (select top 1 COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = sysobjects.name) from sysobjects where type='U'--所有表select * from sysobjects where type='U'--所有表的主鍵 COLUMN_NAMEselect * from INFORMATION_SCHEMA.KEY_COLUMN_U
阅读全文