Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Documents tagged with ""

Your Query returned 3 results

  • Dropping Primary Key Error
    Another error that can be encountered in a database management system is the failure to drop a table due to foreign key constraints. The error message looks something like this: Error description: The primary key 'pk_athlete_code' referred by a foreign key 'fk_game_athlete_code...
    http://www.cubrid.org/wiki_tutorials/entry/dropping-primary-key-error
  • How to Drop Some / All Tables
    Assuming you have no FOREIGN KEY constraints, you can simply select multiple tables using CUBRID Manager, right click and choose the option Manage Table -> Drop Table. Using a SQL command, you can type: DROP TABLE athlete, code, event, game, history, nation, olympic, part...
    http://www.cubrid.org/wiki_tutorials/entry/how-to-drop-some-all-tables
  • Update / Delete Operations Restriction Error
    If you try to update or delete values from a field that is referred by a foreign key that is set to ON UPDATE RESTRICT and/or ON DELETE RESTRICT, then you will encounter a restriction error. The error looks like this: Error description: Update/Delete operation...
    http://www.cubrid.org/wiki_tutorials/entry/update-delete-operations-restriction-error