An example (based on a test database of mine):

-- Just to make the point

USE master;

GO

IF EXISTS

(

SELECT *

FROM Sandpit.sys.identity_columns

WHERE object_id = OBJECT_ID(N'Sandpit.dbo.Product', N'U')

)

BEGIN

PRINT 'It does have an identity column';

END

ELSE

BEGIN

PRINT 'Nope';

END;