OBJECT PROPERTY AND COLUMN PROPERTY TO CHECK PRIMARY KEY AND IDENTITY COLUMN IN SQL SERVER 2005
IF OBJECTPROPERTY ( OBJECT_ID(’employee’) , ‘TABLEHASPRIMARYKEY’ ) = 1
PRINT ‘Yes’
IF COLUMNPROPERTY ( OBJECT_ID(’employee’) , ‘id’, ‘IsIdentity’ ) = 1
PRINT ‘Yes’
Pawan Kumar
Pawankkmr@hotmail.com