Re: [sqlite] Getting Constraints Details

2013-07-02 Thread danap
For some reason I'm using a more complicated version of that same query for constraints. Perhaps its based on some older information that may have been in the table. SELECT type, sql FROM (SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master) WHERE type!='meta' AND sql NOT NULL

Re: [sqlite] Getting Constraints Details

2013-07-01 Thread Kees Nuyt
On Mon, 1 Jul 2013 07:23:54 +, Vijay Khurdiya wrote: >How to get details of constraints associated with Data in SQLite3. > >Ex : I want to find out DEFAULT constraints value associated with data. Some of that info is available in the results of PRAGMA

Re: [sqlite] Getting Constraints Details

2013-07-01 Thread Clemens Ladisch
Vijay Khurdiya wrote: > How to get details of constraints associated with Data in SQLite3. There is no API to get individual properties; you have to look up the original SQL statement: SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'MyTable' > This e-mail and any files

[sqlite] Getting Constraints Details

2013-07-01 Thread Vijay Khurdiya
How to get details of constraints associated with Data in SQLite3. Ex : I want to find out DEFAULT constraints value associated with data. This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.