removed specific version: this limitation is still there today, and no change is in sight

Source Link

edited Jan 17, 2018 at 11:18

How do I add a foreign key to an existing sqlite (3.6.21)SQLite table?

I have the following table:

CREATE TABLE child( 
  id INTEGER PRIMARY KEY, 
  parent_id INTEGER, 
  description TEXT);

How do I add a foreign key constraint on parent_idparent_id? Assume foreign keys are enabled.

Most examples assume you're creating the table - I'd like to add the constraint to an existing one.

How do I add a foreign key to an existing sqlite (3.6.21) table?

I have the following table:

CREATE TABLE child( 
  id INTEGER PRIMARY KEY, 
  parent_id INTEGER, 
  description TEXT);

How do I add a foreign key constraint on parent_id? Assume foreign keys are enabled.

Most examples assume you're creating the table - I'd like to add the constraint to an existing one.

I have the following table:

CREATE TABLE child( 
  id INTEGER PRIMARY KEY, 
  parent_id INTEGER, 
  description TEXT);

How do I add a foreign key constraint on parent_id? Assume foreign keys are enabled.

Most examples assume you're creating the table - I'd like to add the constraint to an existing one.

Fix trivial typo

Link

edited Dec 11, 2009 at 0:08

edited tags

Link

edited Dec 10, 2009 at 23:29

Source Link

asked Dec 10, 2009 at 23:22

Loading