Archives of the TeradataForum

Message Posted: Thu, 21 Nov 2003 @ 04:12:39 GMT

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

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.

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