Posted by David Portas on 11/28/05 21:13

ALTER TABLE table1
ADD CONSTRAINT pk_table1 PRIMARY KEY (col1, col2, col3, col4, col5) ;

Tip: "column" and "row" are the terms usually preferred over "field"
and "record" when discussing SQL databases. Some people will argue that
there are quite different concepts attached to the different names and
that the distinction is a very important one. Others use the names
interchangeably without worrying to much about the formal definitions.
Still, you won't be called wrong if you stick with the terms "column"
and "row". :-)

Hope this helps.

--
David Portas
SQL Server MVP
--

[Back to original message]