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

4 votes304 views3 answers
Mysql update with join
SQL
-1 vote323 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote352 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote292 views1 answer
We are intrested to work with your organization
SQL
0 vote290 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote322 views1 answer
Display all node label neo4j
SQL
2 votes305 views1 answer
Sql ends with string
SQL
2 votes319 views1 answer
Orcale index size
SQL
0 vote315 views1 answer
Create bdd mysql
SQL
0 vote311 views1 answer
Date on SQL
SQL