jan <janus...@gmx.net> wrote:
> is there a way to query the check constraints added to a column
> definition?

Not really. The best you can do is

select sql from sqlite_master
where type='table' and name='your_table_name';

then parse raw SQL. Note that there may be table level check constraints 
involving more than one column (in fact, nothing says that a check 
constraint attached to a column must actually refer to that column and 
that column only).

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to