I will investigate the "alter table" command - thanks.

by spinoff - I mean that the database is too large for the environment to handle so I want to cut the 2008 data from the "main database" and put it in a backup version. The backup version will still be accessible by a different front-end but retain all the same capabilities. Then, I will likely need to spinoff 3-6 months of data at a time - and, preferably,...

Here is a brief summary of what I am trying to achieve:
My database is huge (many tables over 50k records) and I would like to spin off a select set of data. I want to spin off 2008 data, and in 3 months spin off 2009 data -- adding it to the 2008 spin off.

The primary keys in my tables are incremental autonumber. Now, the spin off of 2008 data is relatively easy - because the primary keys retain their relationships. When...