Modifying table structure

I have a database created without any nornalization criteria. There isn't primary or foreign keys. I want to introduce PK

and FK now. Also I'm going to remove some fields and change the format of others fields.

My tables has lot of records. Before introduce the structure changes I'm going to make a backup.

What kind of problems will I have when I try to reload the database? I suppose there will be problems with

format fields, and with referential integrity...any other problems?.

I suppose the order is important in the load process..isn't?. I will begin with the non-FK tables.

Any advice will be greatly apreciatted. Thanks


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!