Yes. CREATE TABLE Parent ( id INTEGER PRIMARY KEY, data TEXT COLLATE NOCASE, CONSTRAINT unique_data UNIQUE (data) );
CREATE TABLE Child ( id INTEGER PRIMARY KEY, parent INTEGER CONSTRAINT child_to_parent REFERENCES Parent(id) ); or CREATE TABLE Child ( id INTEGER PRIMARY KEY, parent INTEGER, CONSTRAINT child_to_parent FOREIGN KEY (parent) REFERENCES Parent(id) ); What do you mean "check for uniqueness? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Igor Korot > Sent: Sunday, 2 July, 2017 21:12 > To: Discussion of SQLite Database > Subject: [sqlite] FOREING KEY constraint > > Hi, ALL, > Is SQLite supports naming a foreign key constraint? > And if it does - is there a way to check for its uniqueness? > > Thank you. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
