On 9/27/2018 9:43 AM, Revathi Narayanan wrote:
I have one requirement like I want to display all the table names for the
given column name.
Ex: If the table T1 and T2 has column names like C1 then it should display
both the table names T1 and T2.
With sufficiently recent SQLite version, you can select from
pragma_table_info('tablename') and get the same resultset as PRAGMA
table_info(tablename): https://www.sqlite.org/pragma.html#pragfunc . These
functions can participate in joins: the table name doesn't have to be a literal.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
