|
|
Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 15:41:56 GMT
Subj: | | Re: Where is the DDL for Temporary Tables stored? |
|
From: | | Michael Larkins |
| May I know where the DDL of all types of Temporary Tables stored | |
As previously mentioned, only the DDL for a Global Temporary table is actually stored in the Data Dictionary. I recommend to my SQL students
that the DDL for a Volatile table be stored in a macro. That way, it is stored in the macro that is stored in the Data Dictionary for easy
access.
Just a suggestion.
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |