VanillaGranilla

SQL get tables w/o primary key

Jan 9th, 2013
320
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. USE [DatabaseName]
  2.  
  3. GO
  4. SELECT TABLE_SCHEMA AS 'SCHEMA', TABLE_NAME AS 'NO_Primary_Key'
  5. FROM INFORMATION_SCHEMA.TABLES
  6.  
  7. WHERE
  8.  
  9. TABLE_NAME NOT IN
  10. ( SELECT TABLE_NAME
  11. FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
  12. WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
  13. ) AND TABLE_TYPE = 'BASE TABLE'
  14. ORDER BY TABLE_SCHEMA, NO_Primary_Key
Advertisement
Add Comment
Please, Sign In to add comment