How to check a primary key exists or not in table

Home >> Dababase Interview Questions >> Sql Server 2005 Query

Posted on December 14th , 2009 by Admin

	IF OBJECTPROPERTY( OBJECT_ID( '[dbo].[Customers]' ), 'TableHasPrimaryKey' ) = 1 PRINT '[dbo].[Customers] table has a primary key.'