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
