SQLite Foreign Key Support

Overview This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19 (2009-10-14). The first section introduces the concept of an SQL foreign key by example and defines the terminology used for the remainder of the document. Section 2 describes the steps an application must take in order to enable foreign key constraints in SQLite (it is disabled by defa

[ihag]

echo "PRAGMA foreign_keys = ON;" > ~/.sqliterc しておけばOKってワケ

[littlepad]

外部キー制約について

[k-holy]

SQLite 3.6.19から使える参照整合性制約いろいろ