![]() ![]() On rc.rdb$constraint_name = c. ||(select list(trim(idet.rdb$field_name)) from rdb$index_segments idet where rdb$index_name = uqc.rdb$index_name) ||') references '||trim(uqc.rdb$relation_name) ![]() ||(select list(trim(imast.rdb$field_name)) from rdb$index_segments imast where rdb$index_name = c.rdb$index_name) ||' add constraint '||trim(c.rdb$constraint_name) select 'alter table '||trim(c.rdb$relation_name) The tool then generates the appropriate alter table drop constraint SQL command for dropping the constraint from the table. The drop constraint function allows the user to enter a constraint to drop from the table. Remember to run this before actually deleting the foreign keys. The RazorSQL alter table tool includes a Drop Constraint option for dropping a constraint from a Firebird database table. To generate a script to re-create all the foreign keys, this script will do the trick (for firebird >= 2.0). A user reports that JIRA fails to create some tables in Firebird, breaking with. Where c.rdb$constraint_type = 'FOREIGN KEY' ![]() Select 'alter table '||c.rdb$relation_name||' drop constraint '||c.rdb$constraint_name||' ' script_lines To generate a script which in turns drop all the foreign keys, use the following script in any firebird >= 2.0 (maybe it works on pre 2.0, just can't remember if data dictionary changed in involved system table): -generate a script which drops all foreign keys
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |