BEGIN TRANSACTION GO CREATE TABLE dbo.ext_user_card_number_import ( user_name varchar(50) NOT NULL, card_number varchar(100) NOT NULL ) GO ALTER TABLE dbo.ext_user_card_number_import ADD CONSTRAINT PK_ext_user_card_number_import PRIMARY KEY CLUSTERED (user_name) GO CREATE UNIQUE NONCLUSTERED INDEX IX_ext_user_card_number_import_card ON dbo.ext_user_card_number_import (card_number) GO COMMIT