Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating a unique column

Status
Not open for further replies.
bonosa

bonosa

Programmer
May 19, 2004
76
US
I googled but cant find it: I need to know how to create a column thats unique when I make my table.
Thanks,
sb
 
Sort by date Sort by votes
Code: 
create table t(c1 char(12), 
constraint uniqueC1 unique(c1),
<other columns>)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
494
spamjim
spamjim
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
448
penguinspeaks
penguinspeaks
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
553
EdLentz
EdLentz
jawadfrhad
  • Locked
  • Question
how make row to column
Replies
4
Views
186
jawadfrhad
jawadfrhad
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
612
BobThornton
BobThornton

Part and Inventory Search

Sponsor

Back
Top