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

schema:scott

A foreign key should refer to a ''candidate key'' in some table. Thi..."

2012-07-17T09:53:45Z

Created page with "CREATE TABLE problems: Foreign key references. <div class='ht'> <div class=params>schema:scott</div> <div> A foreign key should refer to a ''candidate key'' in some table. Thi..."

New page

CREATE TABLE problems: Foreign key references.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
A foreign key should refer to a ''candidate key'' in some table. This is usually the primary key but may be a field (or list of fields) specified as UNIQUE.

You must have REFERENCE permission on the table being referenced.
</div>

<source lang=sql class='tidy'>DROP TABLE t_stupid</source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def'>CREATE TABLE t_stupid (a INTEGER
,FOREIGN KEY(a)
REFERENCES cia(population))
</source>
<div class="ecomm e-mysql" style="display: none">It's an old tart - it will let you reference any old rubbish.</div>
<div class="ecomm e-sqlite" style="display: none">Foreign key references are ignored. This problem does not arise.</div>
</div>
{{CREATE and DROP ref}}

CREATE TABLE problems: Foreign key references. - Revision history

Marek: Created page with "CREATE TABLE problems: Foreign key references. schema:scott A foreign key should refer to a ''candidate key'' in some table. Thi..."

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

schema:scott

A foreign key should refer to a ''candidate key'' in some table. Thi..."