You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE DDL_LOG (
ID INTEGER,
DDL_EVENT VARCHAR(25),
SQL BLOB SUB_TYPE TEXT
);
create or alter trigger DDL_LOG_TRIGGER after any ddl statement
as
begin
insert into ddl_log(SQL, DDL_EVENT)
values (rdb$get_context('DDL_TRIGGER', 'SQL_TEXT'),
rdb$get_context('DDL_TRIGGER', 'DDL_EVENT') );
end
select count(*) from rdb$dependencies d
where d.rdb$dependent_name = 'DDL_LOG_TRIGGER'
or d.rdb$depended_on_name = 'DDL_LOG_TRIGGER'
----------------------
COUNT
0
Submitted by: Alex Bekhtin (afgm)
CREATE TABLE DDL_LOG (
ID INTEGER,
DDL_EVENT VARCHAR(25),
SQL BLOB SUB_TYPE TEXT
);
create or alter trigger DDL_LOG_TRIGGER after any ddl statement
as
begin
insert into ddl_log(SQL, DDL_EVENT)
values (rdb$get_context('DDL_TRIGGER', 'SQL_TEXT'),
rdb$get_context('DDL_TRIGGER', 'DDL_EVENT') );
end
select count(*) from rdb$dependencies d
where d.rdb$dependent_name = 'DDL_LOG_TRIGGER'
or d.rdb$depended_on_name = 'DDL_LOG_TRIGGER'
----------------------
COUNT
0
Commits: d574d43
The text was updated successfully, but these errors were encountered: