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

  • GilaMonster (5/13/2008)


    IF EXISTS (SELECT 1 from master.dbo.sysobjects where name = 'Table1' and xtype = 'U')

    BEGIN

    -- do something here.

    END

    Hi Gila,

    I don't understand, Are you spend all of your day in sql servercentral?, why i am asking this question is before i answer the post always i am finding your post prior

    tell me any special techniq ..........