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
table.

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.

Thanks
Dan