SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
EXCEPT
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
Thursday, December 17, 2009
Subscribe to:
Post Comments (Atom)
Just a place to post my thoughts on C#, SQL Server, Agile Development, and pretty much anything else I come up with.
No comments:
Post a Comment