select * from sys.objects where [object_id] not in ( select parent_object_id from sys.objects where type = 'PK') --where object_id = 88439439 and type_desc = 'USER_TABLE' order by name VEYA USE ANKA; 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
