Check the existance of a table by querying sysobjects : sysobjects « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sysobjects

4>    IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id('Shippers')
5>    AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
6>    DROP TABLE Shippers
7>    GO
1>
2>    CREATE TABLE Shippers(
3>       ShipperID        int         IDENTITY (1, 1) NOT NULL,
4>       CompanyName      nvarchar (40) NOT NULL,
5>       Phone            nvarchar (24) NULL
6>    )
7>    GO
1>
2> drop table Shippers;
3> GO