Re: Where is a temp tables DDL stored?

"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.
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 SQL Compiler Development
> IBM Toronto Lab

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 ?

Here's one for Oracle, by the way, in the SYS account:

  1* select * from bootstrap$ where obj# = 0 SQL> /      LINE# OBJ#
---------- ----------
SQL_TEXT

         0 0
CREATE ROLLBACK SEGMENT SYSTEM STORAGE ( INITIAL 11 2K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 9))

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle - Volume 1: Fundamentals
On-shelf date: Nov 2005

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005