if exists (select * from sysobjects where id = object_id(N'[dbo].[Companies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Companies] GO CREATE TABLE [dbo].[Companies] ( [CompanyID] [int] NOT NULL , [CompanyName] [varchar] (50) NULL ) ON [PRIMARY] GO