How lo drop all foreign keys in database?
Answer / Pranav Kumar Ojha
{"Firebird": "To drop all foreign keys in a Firebird database, you can use the ALTER TABLE statement with NO INHERIT option. However, there is no direct command to drop all foreign keys at once for all tables in the database. You'll need to run this command individually for each table that has foreign keys: ALTER TABLE <table_name> ALTER FIELD <field_name> NOT FOREIGN KEY NO INHERIT."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?
How to pipe multiline string to isqi?
How lo drop all foreign keys in database?
How to connect with firebird database in delphi using tsqlconnection?
How to present flrehird.log file from filling up the disk partition?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)