Serge Rielau wrote:
> 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
Taken literally no. But we often use DDL to mean metadata just as,
in the Oracle world, we often use the words INSTANCE and DATABASE
interchangeably when in fact they are entirely different constructs.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Sep 15 2005 - 10:54:41 CDT
