Mega Code Archive
Creating a UNIQUE Constraints when creating a table
<![CDATA[
5>
6> CREATE TABLE Shippers
7> (
8> ShipperID int IDENTITY NOT NULL
9> PRIMARY KEY,
10> ShipperName varchar(30) NOT NULL,
11> Address varchar(30) NOT NULL,
12> City varchar(25) NOT NULL,
13> State char(2) NOT NULL,
14> Zip varchar(10) NOT NULL,
15> PhoneNo varchar(14) NOT NULL
16> UNIQUE
17> )
18> GO
1>
2> drop table Shippers;
3> GO
]]>