Re: [sqlite] Use of CHECK constraints and Triggers

On 12 Mar 2011, at 9:35am, Jonathan Allin wrote: > I can impose a CHECK constraint on a table when I create it. A perhaps > non-PC example: > > > > CREATE TABLE employers (id INTEGER, name TEXT, age INTEGER, office INTEGER > REFERENCES offices, PRIMARY KEY (id), CHECK (age > 10 AND age < 90))

[sqlite] Use of CHECK constraints and Triggers

I can impose a CHECK constraint on a table when I create it. A perhaps non-PC example: CREATE TABLE employers (id INTEGER, name TEXT, age INTEGER, office INTEGER REFERENCES offices, PRIMARY KEY (id), CHECK (age > 10 AND age < 90)) However: (1)Can I add new check constraints after I've