Home Forums SQL Server 7,2000 T-SQL how to check specified table exists in the database or not RE: how to check specified table exists in the database or not
karthik M
One Orange Chip
Points: 29139
More actions
May 13, 2008 at 2:56 am
#814294
Concur...
if you don't want to do something ,then simply
select name from master.dbo.sysobjects where name ='Table1' and xtype ='U'
karthik