Two field primary key

[Greg Snidow]

Greetings all. I know(think) it is possible, but can anyone explain how to
make a primary key involve two fields? Thank you.

 

[Sylvain Lafontaine]

Using the design tool of ADP, the graphical interface of Enterprise Manager
or T-SQL code?

Also, take note that you may have some problems using composite primary keys
under ADP. I don't know what is now the exact situation with A2003 but with
A200, I seem to remember a lot of problems and I stopped using them with any
project involving ADP.

 

[Greg Snidow]

Sylvain,
I am using the graphical interface of Enterprise Manager (SQL2K) to design
all of my tables. Using T-SQL code is beyond by ability so far. Is it just
as well to use the ADP? I was told to never disign tables with ADP

 

[Sylvain Lafontaine]

On Enterprise Manage, highlight the two columns while in design mode and
click on the little key.

You can also open the Manage Indexes / Keys dialog window and add the field
that you want to an existing primary key.