IF OBJECT_ID('[dbo].[utbMyTable1]') IS NOT NULL DROP TABLE [dbo].[utbMyTable1] GO CREATE TABLE [dbo].[utbMyTable1] ([Col1] INT IDENTITY(1, 1), [Col2] NVARCHAR(10), [Col3] BIGINT, [Col4] IMAGE) ON [PRIMARY] GO ALTER TABLE [dbo].[utbMyTable1] ADD CONSTRAINT [PK_utbMyTable1] PRIMARY KEY CLUSTERED ([Col1]) GO CREATE INDEX IX_utbMyTableCol2 ON [dbo].[utbMyTable1]([Col2]) ON [PRIMARY] GO ALTER TABLE [dbo].[utbMyTable1] ADD CONSTRAINT [UQ_utbMyTable1_Col3] UNIQUE([Col3]) ON [PRIMARY] GO