 |
 |
Archives of the TeradataForum
Message Posted: Thu, 20 Nov 2003 @ 11:47:04 GMT
| Subj: | | Re: Restoring just DDL |
| |
| From: | | David Wellman |
Ian,
I think that the arc "dictionary rows" option will achieve this. After the restore (on your target system) you will then possibly have to
use the "rebuild tables" command so that the developers can reference the tables in their sql.
Building the definition from dbc.tables etc may not work (and at best will be 'tricky' !), not all of the definition components are held
in dictionary tables (e.g. Datablocksize option). Obviously if you don't use those options then this won't affect you. You can't use the
RequestText/Createtext columns as they don't contain the full definition either.
Cheers,
Dave
| |
