-----Original Message-----
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 8:44 AM
To: CF-Talk
Subject: Re: OT: SQL Server Table Design Question
On Mar 18, 2004, at 5:04 AM, Tangorre, Michael wrote:
> 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?
>
So, C is an identity or autonumber field?
I have seen/done this, but not for the reasons you state -- could you expand
on how using C would ease writing of the where clause
Dick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
