Adding Field to Primary Key

Adding Field to Primary Key

Post by DM » Fri, 30 Jul 1999 04:00:00

Please forward any help to resolve this problem:

I am trying to add a field to an existing table and the field needs to be
added as part of the primary key.  The table I am adding this to has a
dependent table.  The trick is that I want to do this without dropping the

What I want to do is:
- Add the new field allowing nulls
- Initialize the existing records to 0
- Change the new field to not allow nulls
- Add the new field to the primary key

How is the best way to handle this problem beyond dropping the tables making
the changes and importing the existing data.