On 9/27/18, Revathi Narayanan <[email protected]> wrote: > Hi, > > 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. > > I tried to execute the query using sqlitemaster. But it's displaying only > table names not column names.
Let the column name be in the variable $c1 SELECT a.name FROM sqlite_master AS a JOIN pragma_table_info(a.name) AS b WHERE a.type='table' AND b.name=$c1; -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
