Re: [sqlite] Getting Constraints Details
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 AND name='MyTable' danap. > 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' ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Getting Constraints Details
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 table_info(yourtablename); -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Getting Constraints Details
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 transmitted with it are for the sole use ... This e-mail contains public information intended for any subscriber of this mailing list and for anybody else who bothers to read it; it will be copied, disclosed and distributed to the public. If you think you are not the intended recipient, please commit suicide immediately. These terms apply also to any e-mails quoted in, referenced from, or answering this e-mail, and supersede any confidentiality notices in those e-mails. Additionally, confidentiality notices in those e-mails will incur legal processing fees of $42 per line; you have agreed to this by reading this confidentiality notice. Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Getting Constraints Details
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. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. The recipient acknowledges that Secure Meters Limited or its subsidiaries and associated companies(collectively "Secure Meters Limited"),are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Secure Meters Limi ted. Before opening any attachments please check them for viruses and defects. In case you have any problem or issue with the E-mails from Secure Meters Limited Please do lets us know on netad...@securetogether.com Secure Meters Limited- Udaipur- Rajasthan -313001 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users