I am reconstructing an existing database. There are some columns that I no longer need. Is it better to use a make table query to create a new table and then establish referential integrity? Or should i create the structure and establish referitial intergirty first then copy the existing records into the new table structure and any other new tables I create.
Make table or update query
- Thread starter lloyd33
- Start date
Lister
Z Shift
- Local time
- Tomorrow, 06:00
- Joined
- Aug 24, 2003
- Messages
- 305
Before doing anything make a back up copy of your database!
If I understand you correctly, I would say that the best way would be copy the table and past it back into the Main Table Window with a different name.
You can then set up any relation links you like without breaking the old ones.
You can also add any new fields that you may need.
You can delete any fields you don’t think you will need safe in the knowledge that the old table is there if you stuff it up.
You can test queries and so on. If you are happy with what you have done, break the link with the old table and delete it.
If it all goes south you have your back up to fall back on and try again.
Create table would do the same but this way you can take an axe to the table with a lot less work.
Hope this helps
If I understand you correctly, I would say that the best way would be copy the table and past it back into the Main Table Window with a different name.
You can then set up any relation links you like without breaking the old ones.
You can also add any new fields that you may need.
You can delete any fields you don’t think you will need safe in the knowledge that the old table is there if you stuff it up.
You can test queries and so on. If you are happy with what you have done, break the link with the old table and delete it.
If it all goes south you have your back up to fall back on and try again.
Create table would do the same but this way you can take an axe to the table with a lot less work.
Hope this helps
Table mod
Some of the columns i will just delete. I will also be adding new fields, and moving some columns to completely new tables, because they are contained in the wrong table. What would you do? To fix a database that was really designed incorrectly.
Pat Hartman said:
Some of the columns i will just delete. I will also be adding new fields, and moving some columns to completely new tables, because they are contained in the wrong table. What would you do? To fix a database that was really designed incorrectly.
