IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RecordingModes]') AND type in (N'U')) DROP TABLE [dbo].[RecordingModes] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RecordingModes]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RecordingModes]( [RecordingModeId] [int] NOT NULL, [RecordingMode] [nvarchar](50) NULL ) ON [PRIMARY] END GO