why not simply use the sys.col table?
Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in article
<35B69409.5A0E_at_comp.polyu.edu.hk>...
> Hello all,
>
> Is is possible to audit the table structure? i.e. I have a table A
> which stores the table structure of table B. If I add a column to table
> B, a newly row will be inserted automatically to table A to keep track
> the new column characteristic such as name, date of creation, who create
> the column etc. Is it possible do that by trigger and PL/SQL stored
> procedures?
>
> Thanks,
> Jimmy
>
Received on Thu Jul 23 1998 - 08:23:45 CDT
