Re: Where is a temp tables DDL stored?

Daniel Fink wrote:
> I think we are disagreeing over semantics.
>
> I consider DDL to be the command that creates (or modifies) the object,
> i.e. CREATE TABLE emp <...>; This command is not stored in the data
> dictionary.
>
> However, all the information to reconstruct this command IS stored in
> the data dictionary and can be extracted using a variety of
> tools/techniques.
>

I'm curious, do you know of any DBSM which store the DDL for a table? Reason being why this generally is not done is that schema-evolution either will outdate the DDL text very quickly, or cause a maintenance nightmare for DBMS developers.
Most systems I know leave it to tooling to reverse engineer the current, up to date, DDL for a table (and other objects) from the data dictionary.

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab