response to my self, is it correct? execute block returns (drop_index_name varchar(31), dropped boolean) as declare variable doit boolean; declare variable stmt varchar(2048); begin dropped=false; -- test before for select i.rdb$index_name from rdb$indices i where (i.rdb$system_flag<>1) and (i.rdb$unique_flag<>1) and (rdb$foreign_key is null) into :drop_index_name do begin stmt='drop index '||:drop_index_name||';'; if (dropped) then execute statement :stmt; suspend; end end
Em qui., 12 de mar. de 2020 às 17:59, hamacker <sirhamac...@gmail.com> escreveu: > > Is it possible to drop all indexes, except those related to PK and FK? > > I would like to do a test and recreate them by script. > >