USE SnappingTest
GO
CREATE TABLE DBO.FreeGift
(
FreeGiftID int identity(1,1) not null,
FreeGiftType char(1) not null default('')
)
alter table dbo.FreeGift add constraint PK_FreeGift primary key (FreeGiftID)
go
select * from snappingtest.dbo.FreeGift(nolock)
create index IX_FreeGift_FreeGiftType on dbo.freegift(FreeGiftType)
