Re: alter table rename column can event trigger capture new column name

[jian he <jian.universality@xxxxxxxxx>]

On Mon, Apr 24, 2023 at 10:46 AM jian he <jian.universality@xxxxxxxxx> wrote:

hi.

alter table t1 rename col1 to id.

Is it possible to use an event trigger to capture the new column name "id"? 

sorry for the noise. 

I figured it out. 

substring(_object_identity FROM (LENGTH(_object_identity) + 2 - STRPOS(REVERSE(_object_identity), '.')))