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 vote147 views2 answers
Default constraint in ms sql
SQL
0 vote186 views1 answer
Mysql command line top 10
SQL
2 votes239 views1 answer
Mysql create user with remote access
SQL
0 vote152 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote298 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote176 views1 answer
Add new column in sql with foreign key
SQL
10 votes161 views2 answers
Rtrim sql
SQL
11 votes157 views2 answers
Docker create postgres db
SQL
0 vote170 views1 answer
Replace string in whole database mysql stackoverflow
SQL
2 votes153 views2 answers
Postgres trigger insert into another table
SQL