| 数据库 | SQL 示例 |
|---|---|
| MySQL | sql CREATE TABLE child ( child_id INT PRIMARY KEY, parent_id INT, FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ); |
| PostgreSQL | sql CREATE TABLE child ( child_id SERIAL PRIMARY KEY, parent_id INT, FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ); |
| SQLite | sql CREATE TABLE child ( child_id INTEGER PRIMARY KEY, parent_id INTEGER, FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ); |
| SQL Server | sql CREATE TABLE child ( child_id INT PRIMARY KEY, parent_id INT, CONSTRAINT fk_parent FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ); |
| Oracle | sql CREATE TABLE child ( child_id NUMBER PRIMARY KEY, parent_id NUMBER, CONSTRAINT fk_parent FOREIGN KEY (parent_id) REFERENCES parent(parent_id) ); |
