How To- Check Primary Key Exists or not in Table

 TO check primary key existence in table

IF OBJECTPROPERTY( OBJECT_ID( '[dbo].[MyTestTable]' ), 'TableHasPrimaryKey' ) = 1

   PRINT '[dbo].[MyTestTable] table has a primary key.'

ELSE

   PRINT '[dbo].[MyTestTable] table has no primary key.'

 

Posted in: SQL