Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Use OBJECTPROPERTY and OBJECT_ID to check the table existance

5> USE master 6> SELECT OBJECTPROPERTY(OBJECT_ID('syslockinfo'), 'TableIsFake'), 7>     OBJECTPROPERTY(OBJECT_ID('sysobjects'), 'TableIsFake') 8> GO Changed database context to 'master'. ----------- -----------        NULL        NULL (1 rows affected) 1>