if exists (select * from dbo.sysobjects where id = object_id(N'[Polaris].[SLCO_YEAR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [Polaris].[SLCO_YEAR] GO create table [polaris].[SLCO_YEAR]( [SLCO_YEAR] [int] Not Null, [YDescription] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) on [Primary] GO ALTER TABLE Polaris.SLCO_YEAR WITH NOCHECK ADD CONSTRAINT PK_SLCO_PYMonth PRIMARY KEY (SLCO_YEAR) on [PRIMARY]