Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 09:25:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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.

Thanks,

Ravi Pratap
(Teradata certified DBA)

	<Prev	Next>		<<First	<Prev	Next>	Last>>