代码改变世界

查找没有主键的table

2013-02-27 13:33  Sam Jin  阅读(163)  评论(0)    收藏  举报 
GO
 SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
 FROM sys.tables
 WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0
 ORDER BY SchemaName, TableName;
 GO