Foreign key sqlite3 python

Sqlite foreign key

CREATE TABLE track(
  trackid     INTEGER, 
  trackname   TEXT, 
  trackartist INTEGER,
  FOREIGN KEY(trackartist) REFERENCES artist(artistid)
);

Source: sqlite.org

Foreign key sqlite3 python

CREATE TABLE supplier_groups (
	group_id integer PRIMARY KEY,
	group_name text NOT NULL
);

CREATE TABLE suppliers (
    supplier_id   INTEGER PRIMARY KEY,
    supplier_name TEXT    NOT NULL,
    group_id      INTEGER NOT NULL,
    FOREIGN KEY (group_id)
       REFERENCES supplier_groups (group_id) 
);
Code language: SQL (Structured Query Language) (sql)

Source: sqlitetutorial.net

Similar codes

0 vote125 views2 answers
Sql day from datetime
SQL
13 votes128 views2 answers
Display users in mysql
SQL
0 vote153 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote129 views1 answer
Show size of all tables postgres
SQL
0 vote186 views1 answer
ORA-01400
SQL
103 votes302 views1 answer
Like sql
SQL
0 vote143 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote145 views1 answer
Copy row from db to db mysql
SQL
0 vote132 views1 answer
Change filed order in mysql
SQL
0 vote144 views1 answer
Recently updated stored procedure in sql server
SQL