Archives of the TeradataForum
Message Posted: Thu, 02 Aug 2012 @ 23:02:45 GMT
| Subj: || || Re: Using COPY command to copy tables |
| From: || || Fenwick, Ruth |
You don't need to delete the data on the target system.....COPY will actually drop and recreate the table structure for you....so if your table
happened to have a different structure on the target (say a missing column), COPY to will replace it with the table structure from the source. It
will also bring over any statistics you had on the tables.
What I don't remember is what would happen if you had an extra table in the target database and you did a database level COPY ....that extra
table may get dropped, but as I said, I don't remember.