Re: Where is a temp tables DDL stored?

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 16 Sep 2005 09:20:33 -0400
Message-ID: <3ovv54F8193lU1@individual.net>

Jonathan Lewis wrote:

> "Serge Rielau" <srielau_at_ca.ibm.com> wrote in message 
> news:3ot6mnF7lievU1_at_individual.net...
> 

>>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.
>>

> Just playing devil's advocate, but why couldn't
> the database reverse engineer the corrected
> DDL from the data dictionary as the dictionary
> is updated ?

Wouldn't that be poor database design?
I could settle for a view which composes the DDL from the bits and pieces available.

Cheers
Serge

PS: Does bootstrap contain the scripts to create a database/instance? That would make sense then since this DDL is the cause for what you later find in the catalogs (and which won't change - a lot)

PPS: Feisty comments regarding the clearness of "DDL" shall be forfeit.

PPPS: I'm not Godfrey. I have never met Daniel despite his numerous invitations to class and I can't type Godfreys long posts without spelling errors as he does.

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Received on Fri Sep 16 2005 - 08:20:33 CDT