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

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] Replace of substring in sqlite-table - how can I do this?

Hi Donald, thanks for this valuable comment. Regarding the regexp-function, I am not really sure whether I understood it entirely or not: is it correct that I can use the regexp *only* in external programs (e.g. a perl programme), but not on the sqlite command line? There is no possibility to

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Peter, thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed! Best regards, Wolfgang Am Montag 07 August 2006 pH:19:16 nachmittags/abends schrieb Peter Cunderlik: > On 8/7/06, wq

[sqlite] Replace of substring in sqlite-table - how can I do this?

Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one? I do not know, what would be the right