Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How lo drop all foreign keys in database?



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

Post New Answer

More Firebird Interview Questions

Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?

1 Answers  


How to pipe multiline string to isqi?

1 Answers  


How lo drop all foreign keys in database?

1 Answers  


How to connect with firebird database in delphi using tsqlconnection?

1 Answers  


How to present flrehird.log file from filling up the disk partition?

1 Answers  


Categories