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
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
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
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.
4 matches
Mail list logo