Breaking News: Grepper is joining You.com. Read the official announcement!

create more than 1 tables with references to each other in sqlite3

Strange Snail answered on December 18, 2021 Popularity 5/10 Helpfulness 2/10

answer create more than 1 tables with references to each other in sqlite3

related create more than 1 tables with references to each other in sqlite3

create more than 1 tables with references to each other in sqlite3

Comment

DROP TABLE suppliers;

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)

Popularity 5/10 Helpfulness 2/10 Language sql

Source: www.sqlitetutorial.net

Tags: each sql

Link to this answer
Share Copy Link

Contributed on Dec 18 2021

Strange Snail

0 Answers Avg Quality 2/10

Closely Related Answers

create more than 1 tables with references to each other in sqlite3

Comment

INSERT INTO suppliers (supplier_name, group_id)
VALUES('XYZ Corp', 1);

INSERT INTO suppliers (supplier_name, group_id)
VALUES('ABC Corp', 2);
Code language: SQL (Structured Query Language) (sql)

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.sqlitetutorial.net

Tags: each sql

Link to this answer
Share Copy Link

Contributed on Dec 18 2021

Strange Snail

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

create more than 1 tables with references to each other in sqlite3

Contents

More Related Answers

create more than 1 tables with references to each other in sqlite3

Closely Related Answers

create more than 1 tables with references to each other in sqlite3

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.