joshua1218

 Profile Answers by joshua1218 

• Jun 30th, 2008

 

Unique

sivasangari_2006

 Profile Answers by sivasangari_2006 

• Jan 30th, 2009

 

create table <tablename> (field1 datatype contraint constraint-name constraint_type,fields2,field3.........)
(or)
alter table <tablename> add constraint constraint constraint_name constraint_type(fieldname)

Eg:

create table emp(eno int constraint uni1 unique,ename varchar(20)

cybersavvy

 Profile Answers by cybersavvy 

• Feb 19th, 2009

 

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