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

  • Concur...

    if you don't want to do something ,then simply

    select name from master.dbo.sysobjects where name ='Table1' and xtype ='U'

    karthik