Search This Blog

Tuesday, February 8, 2011

How to find Out Table Properties using OBJECTPROPERTY

DECLARE
SELECT
 select OBJECTPROPERTY(@objectID,'TableDeleteTrigger') AS 'Table Has A Delete Trigger',OBJECTPROPERTY(@objectID,'TableHasClustIndex') AS 'Table Has A Clustered Index',OBJECTPROPERTY(@objectID,'TableHasIdentity') AS 'Table Has An Identity Column',OBJECTPROPERTY(@objectID,'TableHasPrimaryKey') AS 'Table Has A Primary Key',OBJECTPROPERTY(@objectID,'TableHasTimestamp') AS 'Table Has A Timestamp',OBJECTPROPERTY(@objectID,'TableHasUniqueCnst') AS 'Table Has A Unique Constraint',OBJECTPROPERTY(@objectID,'IsAnsiNullsOn') AS 'ANSI NULLS Is Set To ON'
@objectID INT @objectID =OBJECT_ID('tablename')

No comments:

Post a Comment