Re: [sqlite] Why am I not getting anything?

Thank you. On Sun, Feb 10, 2019 at 1:35 AM Shawn Wagner wrote: > > SELECT * FROM pragma_foreign_key_list('temp1'); > > The table name needs to be a string for the pragma_foreign_key_list virtual > table. (It's not for the corresponding pragma statement.) > > On Sat, Feb 9, 2019, 11:31 PM Igor Kor

Re: [sqlite] Why am I not getting anything?

SELECT * FROM pragma_foreign_key_list('temp1'); The table name needs to be a string for the pragma_foreign_key_list virtual table. (It's not for the corresponding pragma statement.) On Sat, Feb 9, 2019, 11:31 PM Igor Korot Hi, ALL, > > [code] > sqlite> SELECT * FROM sqlite_master WHERE name LIKE

[sqlite] Why am I not getting anything?

Hi, ALL, [code] sqlite> SELECT * FROM sqlite_master WHERE name LIKE '%temp%'; type|name|tbl_name|rootpage|sql table|temp|temp|40|CREATE TABLE temp(id INTEGER PRIMARY KEY, name VARCHAR(200)) table|temp1|temp1|41|CREATE TABLE temp1(myid INTEGER PRIMARY KEY, id INTEGER, my name VARCHAR(200), CONSTRAI