SQLzoo.net

CREATE TABLE problems: Foreign key references.

SQLite

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.
Run the tidy code silently


Specific to SQLite
Foreign key references are ignored. This problem does not arise.

Related links:

  • CREATE, DROP and ALTER