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 created the table? (2) How can I list all the existing check constraints? (3) Can I also see which triggers have been created? As a general comment, it would seem essential that a SQLite database file can be interrogated to identify ALL of its metadata. There are pragmas etc to access table names, details of table columns, and indexes. However I couldn't see any way to identify check constraints and triggers. Many thanks, ¬Jonathan Allin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
