Answers for "make field unique constraint sql server"

constraint unique mssql

ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col_name); 
ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col1, col2); -- Multiple
ALTER TABLE table_name ADD col_name NUMBER UNIQUE;				  	-- New field

unique constraint mssql

USE AdventureWorks2012;  
GO  
CREATE TABLE Production.TransactionHistoryArchive4  
 (  
   TransactionID int NOT NULL,   
   CONSTRAINT AK_TransactionID UNIQUE(TransactionID)   
);   
GO