Re: multi-field primary key

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
--

.

Relevant Pages

  • Re: Creation of portal site
    ... There are default names for the SQL databases, ... Hollis D. Paul [MVP - Outlook] ... Mukilteo, WA USA ... Prev by Date: ...
    (microsoft.public.sharepoint.portalserver)
  • Specs!
    ... We need a outside provider to connect to 2 of our SQL Databases. ... going to use Terminal Services. ... Prev by Date: ...
    (microsoft.public.windows.terminal_services)