SET ANSI_NULLS ON
go
SET QUOTED_IDENTIFIER ON
go
SET ANSI_PADDING ON
go
SET ANSI_WARNINGS ON
go
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TEMP_WorkstationSetup]') AND type = 'U')
   DROP TABLE [dbo].[TEMP_WorkstationSetup]
go

CREATE TABLE  [dbo].[TEMP_WorkstationSetup]
(   [PK_WorkstationSetup] VARCHAR(50) NOT NULL,
   [Location] VARCHAR(30) NULL,
   [ReceiptPrinter] VARCHAR(80) NULL,
   [ReceiptCopiesToPrint] INT NULL DEFAULT 1 
)

go

INSERT INTO [dbo].[TEMP_WorkstationSetup] ([PK_WorkstationSetup],[Location],[ReceiptPrinter],[ReceiptCopiesToPrint])
SELECT [PK_WorkstationSetup],[Location],[ReceiptPrinter],[ReceiptCopiesToPrint]
FROM [dbo].[WorkstationSetup]
go

IF @@error=0
BEGIN
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WorkstationSetup]') AND type = 'U') AND EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TEMP_WorkstationSetup]') AND type = 'U')
   DROP TABLE [dbo].[WorkstationSetup]

EXECUTE sp_rename '[dbo].[TEMP_WorkstationSetup]', 'WorkstationSetup', 'OBJECT'

ALTER TABLE  [dbo].[WorkstationSetup]
ADD CONSTRAINT [PK_WorkstationSetup_idx] PRIMARY KEY NONCLUSTERED  ([PK_WorkstationSetup] ASC)
WITH ( IGNORE_DUP_KEY = OFF)


END
ELSE
BEGIN
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TEMP_WorkstationSetup]') AND type = 'U')
   DROP TABLE [dbo].[TEMP_WorkstationSetup]

END
go