Hi
If you join with contraints you have better control.
An personally i prefere easier way, like simple select.
If you really need to delete all instead of PK and FK you should not exclude
uniques as you ommit custom unique indexes.
SELECT
'DROP INDEX ' || TRIM(I.RDB$INDEX_NAME) || ';',
Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released in
October 2019. The official version on the Firebird website is 3.0.5.33220,
released in January 2020. This is ok in terms of stability, if I want to
use the Ubuntu package?
Thanks
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