Archives of the TeradataForum
Message Posted: Wed, 13 Oct 2010 @ 09:25:31 GMT
I have to copy some tables from a Test-box to Dev environment WITHOUT DATA. One way to do this is to execute SQL Show table for every table in Test, extract the DDL and create the same table in Dev. But there are more than 1000 tables to be copied in several databases, this approach would not work.
I want to know if there is any option like NO DATA in Restore utility which copies only table headers and pertaining dictionary rows (Not the data rows) to target System. If not, what could be the best possible way to do this.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023