Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Divide table
- Thread starter apffal
- Start date
I would start by reading 'The Fundamentals of Relational Database Design' to make sure you understand how relational databases work. Then I would make sure that the table really needs to be split up. If it does, I would write down all the existing fields and determine which table they should go into and how the key fields relate to each other. Then I would write some insert statements to take the existing information and insert it all into the new tables.
HTH
Leslie
HTH
Leslie
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question