On Mon, Apr 24, 2023 at 10:46 AM jian he <jian.universal...@gmail.com> 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), '.')))