MySQL(?) to SQLite [duplicate]

Question

I want to add this into SQLite, but I can't get alter table to work with add foreign key. It looks like this:

create table Medlem (Mnr integer not null, Namn varchar(6), Telefon varchar(10), primary key (Mnr));



create table Sektion

(Skod char(1) not null,

Namn varchar(14),

Ledare integer,

primary key (Skod));


create table Deltar

(Medlem integer not null,

Sektion char(1) not null,

primary key (Medlem, Sektion));

alter table Sektion add foreign key (Ledare) references Medlem (Mnr); alter table Deltar add foreign key (Medlem) references Medlem (Mnr); alter table Deltar add foreign key (Sektion) references Sektion (Skod);

Do you have foreign key support enabled? (see sqlite.org/foreignkeys.html) — Raad
– Raad, Commented Mar 13, 2013 at 17:11
@Raad A CREATE TABLE command operates the same whether or not foreign key constraints are enabled — Kermit
– Kermit, Commented Mar 13, 2013 at 17:13

Kermit · Accepted Answer · 2013-03-13 17:17:19Z

2

The only way to implement a foreign key constraint in SQL Lite is during CREATE TABLE:

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

It is not possible to use the ALTER TABLE ... ADD COLUMN syntax to add a column that includes a REFERENCES clause, unless the default value of the new column is NULL. Attempting to do so returns an error.

Documentation

edited Mar 13, 2013 at 17:17

answered Mar 13, 2013 at 17:11

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

newbie4life Over a year ago

Thank you, I think I got it now.

Collectives™ on Stack Overflow

MySQL(?) to SQLite [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related