Query to Check if a table is system table or User table | SansSQL

Friday, June 6, 2008

Query to Check if a table is system table or User table

SELECT OBJECTPROPERTY(OBJECT_ID('TableName'), 'IsMSShipped')
0 --> Indicates User Table
1 --> Indicates System Table
Posted by Sandesh Segu
Labels:

1 comment:

Post a Comment

Subscribe to: Post Comments (Atom)

Ads