Archives of the TeradataForum
Message Posted: Thu, 21 Nov 2003 @ 04:12:39 GMT
| Subj: | | Re: Restoring just DDL |
| |
| From: | | Klindt, Jerry |
If you normally use views to access your tables, another variation to Donald's query is to submit a query similar to the one
Donald shows, to get a list of the views. Instead of "show table " put the words "show select * from " in front of the view name.
Then you can submit the output of that query as a second query. Then submit the output of the second query to the test system.
The advantage of "show select * from " instead of "show table " is that you (obviously) get the view definitions, and also that
you get definitions of any other objects, such as join indexes or triggers, that are defined on the underlying tables. That may or
may not be important for your intended use.
If you have more than one view that references a particular table, you may get more than one definition of the table. That's
relatively harmless, as subsequent definitions will merely get a "duplicate table" error when you submit the script to the test
system.
You may have to do some preliminary manual setup on the test system, such as creating the databases. And you may have to do some
final setup, such as granting access rights appropriately, before you can syntax-check your queries under development.
| 
