Marek: Created page with "DROP TABLE problems: Foreign key references.

schema:scott

You may not drop a table if it is referenced by another table.
..."

2012-07-17T09:43:24Z

Created page with "DROP TABLE problems: Foreign key references. <div class='ht'> <div class=params>schema:scott</div> <div> You may not drop a table if it is referenced by another table. </div> ..."

New page

DROP TABLE problems: Foreign key references.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
You may not drop a table if it is referenced by another table.
</div>

<source lang=sql class='tidy'>
DROP TABLE t_b;
DROP TABLE t_a
</source>
<source lang=sql class='setup'>
CREATE TABLE t_a (i INTEGER NOT NULL PRIMARY KEY);
CREATE TABLE t_b (j INTEGER,
FOREIGN KEY(j) REFERENCES t_a(i));
</source>

<source lang='sql' class='def'>DROP TABLE t_a
</source>

<div class="ecomm e-mysql" style="display: none">Foreign keys are not implemented in MySQL so this problem does not arise.</div>
<div class="ecomm e-oracle" style="display: none">The CASCADE CONSTRAINTS clause can be used to remove the references. <pre>DROP TABLE t_a CASCADE CONSTRAINTS</pre></div>
<div class="ecomm e-sqlserver" style="display: none">
We can find out what the foreign keys are using
<tt>sp_help ''table_name''</tt>
</div>
<div class="ecomm e-mysql" style="display: none">The (implicit) trigger gets dropped automatically.</div>
</div>
{{CREATE and DROP ref}}

DROP TABLE problems: Foreign key references. - Revision history

Marek: Created page with "DROP TABLE problems: Foreign key references. schema:scott You may not drop a table if it is referenced by another table. ..."

Marek: Created page with "DROP TABLE problems: Foreign key references.

schema:scott

You may not drop a table if it is referenced by another table.
..."