Re: [sqlite] how to list table making a view

Dennis Cote wrote: Noel Frankinet wrote: Lawrence Chitty wrote: You may be able to do this using the 'explain' statement for example, I have a view called 'myview'. Wrapping this into an sql select statement and proceeding this with explain e.g. > explain select null from myview gives

Re: [sqlite] how to list table making a view

Noel Frankinet wrote: Hello, Is there a better way to list all table making a view than parsing SQL. Is there an API ? You may be able to do this using the 'explain' statement for example, I have a view called 'myview'. Wrapping this into an sql select statement and proceeding this with