Thread: How to declare Composite Keys?
View Single Post
  #2 (permalink)  
Old 05-29-2006, 04:16 PM
irfanhab irfanhab is offline
Junior Member
  
Join Date: May 2006
Posts: 10
irfanhab is on a distinguished road
Default SQL 92 answer. Re: How to declare Composite Keys?
[sql]
ALTER TABLE tablename
ADD CONSTRAINT constraint_name
PRIMARY KEY (attribute1,attribute2)
[/sql]
Reply With Quote