Write a sql query or script to get or list out all
tables in a database which has not any primary key in sql server
SELECT name
FROM sys.tables t
WHERE NOT EXISTS(SELECT 1
FROM sys.indexes i
WHERE t.object_id = i.object_id
AND is_primary_key = 1)
FROM sys.tables t
WHERE NOT EXISTS(SELECT 1
FROM sys.indexes i
WHERE t.object_id = i.object_id
AND is_primary_key = 1)
No comments:
Post a Comment