>How can I change the location of the table in the database. I want to create all the tables and
>database in one location and copy everything to another.
>This is done daily as the data is imported from extracts off of mainframe info.
>
It's not too clear what you're up to...you want to copy all the tables form one dbc to another? Why not just copy the entire directory?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.