Hello, On 2017-12-10 07:21, Igor Korot wrote:
The CREATE TABLE statement supports the following syntax:CREATE TABLE( <column_name_list>, CONSTRAINT <fk_name> FOREIGN KEY(<fk_field>) REFERENCES <ref_table>(ref_column_list>); However, the statement "PRAGME foreign_key_list;" does not list the foreign key name ("fk_name" in the statement above). Does the info for the aforementioned PRAGMA stored somewhere? If yes - does it include the key name and it just not printed with the PRAGMA? If not - does this mean that the only way to get the name is to parse the sql from sqlite_master? Or there is a better way?
The answer is ``not''. Constraint names are ignored and disappearing without a trace except for ``CHECK'' constraint (the name is used to build an error message). Unparsed ``sql'' column of ``sqlite_master'' is the sole place which contains an indirect info about ``FOREIGN KEY'' constraint's name.
-- best regards Cezary H. Noweta _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
