How To Define Unique Key in SQL Server

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

CREATE TABLE product(pid INT PRIMARY KEY,pname VARCHAR(10),invoiceid INT UNIQUE)

sivasangari_2006

 Profile Answers by sivasangari_2006 Questions by sivasangari_2006

• Jan 30th, 2009

Create table (field1 datatype contraint constraint-name constraint_type,fields2,field3.........)(or)alter table add constraint constraint constraint_name constraint_type(fieldname)Eg:create table emp(eno int constraint uni1 unique,ename varchar(20)

Answer Question  Select Best Answer