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

1 comment:

Post a Comment

Ads