Two field primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings all. I know(think) it is possible, but can anyone explain how to
make a primary key involve two fields? Thank you.
 
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.
 
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
 
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.
 
Back
Top