See https://sqlite.org/lang_createtable.html
--
˙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
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,
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
積丹尼 Dan Jacobson wrote:
> file:///usr/share/doc/sqlite3-doc/wal.html should mention the common case
> where
> the user (let's say someone from a different project) has encountered
> cookies.db cookies.db-shm cookies.db-wal
> left behind by some program. User wishs to clean this up, leaving only
4 matches
Mail list logo