Lorenzo Lamas wrote:
Is it there a sentence that lets me delete all foreign keys in a database?
Milan Babuskov answers:
Do this:
select 'ALTER TABLE '|| r.rdb$relation_name || ' DROP CONSTRAINT ' || r.rdb$constraint_name || ';'
from rdb$relation_constraints r
where (r.rdb$constraint_type='FOREIGN KEY')
Then copy/paste the results and execute.