Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [DatabaseName]
- GO
- SELECT TABLE_SCHEMA AS 'SCHEMA', TABLE_NAME AS 'NO_Primary_Key'
- FROM INFORMATION_SCHEMA.TABLES
- WHERE
- TABLE_NAME NOT IN
- ( SELECT TABLE_NAME
- FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
- WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
- ) AND TABLE_TYPE = 'BASE TABLE'
- ORDER BY TABLE_SCHEMA, NO_Primary_Key
Advertisement
Add Comment
Please, Sign In to add comment