pragma table_info(my_table) --> (returns my_table with info for each row)
But this doesn't:
i tried with and without quotes around my table name, no effect. what am i missing or misunderstanding?
SELECT * FROM pragma_table_info(my_table) returns --> near "(": syntax error
I am using:
select sqlite_version() --> 3.7.13
Pragma functions were added in 3.16. On a related note, 3.7.13 will hit 9 years old in just 8 days. You should update if at all possible to get nearly a decade of bug fixes and features.
thanks, wow indeed that's an antique version, unfortunately that's all we got in this Coursera class project, so i can't do much else than forwarding your just advice.
That feature was added in 3.16.0 (2017-01-02). Version 3.7.13 dates from 2012-06-11.