Wednesday 7 September 2011

Composite key in sql


Composite key:


 Composite key has one or more attribute  of field.
Example:
CREATE TABLE SAMPLES(ID NUMERIC(10),NAME NVARCHAR(50),CCODE NVARCHAR(50) PRIMARY KEY(ID,CCODE))

No comments:

Post a Comment