Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-01 : 20:18:07
|
David writes "I have a problem where my 'numbered table' and its related 'comment table' went to far with its key. The problem column is a quantity field. I now have to be able to update this quantity (which is in the Primary key!) and I can not get around a Foreign Key problem. Since these tables do not need this quantity column as a primary key, I am hopeing SQL7 can be easly scripted to remove this column from the PK. Script is the only solution for the multiple locations.
I think I found a quick fix to the Foreign Key problem
ALTER TABLE 'comment table' NOCHECK CONSTRAINT fk__...
But I am still looking for the correct fix.
Also, scripting the constraint key on each machine, how do I know the name fk__... is the correct name on each machine?" |
|
|
|
|
|
remove part of Primary Key