SQL Server

Tables Without a Primary Key

Posted on by WARDY IT Solutions

The following TSQL script will identify all tables in a databases that do not have a Primary Key:

EXEC sp_MSforeachtable ‘SELECT CASE WHEN OBJECTPROPERTY(OBJECT_ID(”?”), ”TableHasPrimaryKey”) = 0 THEN ”?” + ” – Missing PK” ELSE ”?” END’

WARDY IT Solutions

WARDY IT Solutions - Australia's leading SQL Server consultants, trainers and Business Intelligence specialists. WARDY IT Solutions has established itself amongst the top solution providers in SQL Server technologies providing solutions for customers throughout Asia Pacific.