Sunday, 9 October 2011

SAS SQL Constraints-Unique

nThe UNIQUE constraint uniquely identifies each record in a database table.
Query:
CREATE TABLE EMPtbl1
(EMPID int NOT NULL UNIQUE,
EMPname varchar(255) NOT NULL,
company varchar(255),
salary varchar(255),
Location varchar(255))

No comments:

Post a Comment