What is the proper, or preferred way of doing the following:


I have three tables:


T1 - PK A
T2 - PK B
T3 - PK AB (compound)


Is it acceptable to add column C to T3 and make that the PK, and then add a
unique constraint to AB? This would ease writing in writing of the WHERE
clauses when updating and deleting and such...


Thoughts?


Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to