Re: Need to write trigger for "adding a new table"

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 7 Mar 2005 18:37:00 -0500
Message-ID: <6_OdnfbAwK4BeLHfRVn-3w@comcast.com>

<deanbrown3d_at_yahoo.com> wrote in message news:1110237417.408305.251240_at_g14g2000cwa.googlegroups.com...
> But I can't add a trigger to ALL_TABLES because its a view. What to do?
>
>
> I need to create an update-log table for our database, to write out
> additions of (and changes to) any new tables, so that we can see what
> changes have been made recently. This is to be used in conjunction with
> the change-manager, so please don't go there. I am just not sure how to
> write a trigger for a view. This particular view looks horrendous!
>
> THX!
>
> Dean
>

you want a database trigger

see the CREATE TRIGGER ... BEFORE ... ddl_event syntax

++ mcs Received on Mon Mar 07 2005 - 17:37:00 CST