Subject How to copy one table from one database to another, then drop table in originating database.
Author Adrian Wreyford
I have to upgrade a clients databases for a software upgrade.

Database1 has tableA in it which must be copied to database2

TableA and all its data must be copied.

The generator for table a also needs to be copied.

Both the TableA and GeneratorA for database1 must then be dropped.

Can I do this using DSQL, or what do you suggest the easiest way.

Can you please supply an example



[Non-text portions of this message have been removed]