Re: [sqlite] List all views in my sqlite-database - possible?

2006-09-26 Thread Dennis Cote
wqual wrote: is there a way to list all views of my database? Something like the .tables-command for tables would be great. I would be glad for some hints on this issue! Wolfgang, You can use the following query to get the view names from the sqlite_master table. select name from

[sqlite] List all views in my sqlite-database - possible?

2006-09-26 Thread wqual
Hi list, is there a way to list all views of my database? Something like the .tables-command for tables would be great. I would be glad for some hints on this issue! Best, Wolfgang - To unsubscribe, send email to [EMAIL

Re: [sqlite] List all views in my sqlite-database - possible?

2006-09-26 Thread Martin Jenkins
wqual wrote: Hi list, is there a way to list all views of my database? Something like the .tables-command for tables would be great. I would be glad for some hints on this issue! .schema Martin - To unsubscribe,