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')
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