Re: [sqlite] How to retrieve table names for the given string

I got the output by executing the below query, select * from sqlite_master where sql like '%column name% On Fri, Sep 28, 2018, 11:55 AM Revathi Narayanan wrote: > Thanks Keith.. but I am getting an error while joining pragma table info. > > On Fri, Sep 28, 2018, 6:30 AM Keith Medca

Re: [sqlite] How to retrieve table names for the given string

ey > from SysIndexes > join pragma_index_xinfo(IndexName) > ); > > then > > select ObjectName as TableName > from SysColumns > where ColumnName == ? >and ObjectType = 'table'; > > > --- > The fact that there's a Highway to Hell but onl

Re: [sqlite] How to retrieve table names for the given string

Thanks Richard. But I am getting an error like near ( syntax error. Pragma table_info(a.name) On Fri, Sep 28, 2018, 6:21 AM Richard Hipp wrote: > On 9/27/18, Revathi Narayanan wrote: > > Hi, > > > > I have one requirement like I want to display all the table names for

[sqlite] How to retrieve table names for the given string

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