extract the SQL statment from SQLITE_MASTER
drop the original view/index/trigger
alter the SQL string to replace the original name with the new name
execute the altered SQL statement
seems a bit heavy handed…was hoping for a “clean” method[/quote]
Unfortunately this is the only way at the moment.
short : you must copy all the datas in another table, then delete the old table.[/quote]
No, I really did mean http://sqlite.org/lang.html as that shows the limits of SQLite’s SQL syntax, i.e. it’s missing ALTER <ANYTHING EXCEPT TABLE>.
I think I will go with the method I mentioned in my OP…
Altering SQLITE_MASTER directly via PRAGMA does not seem to be a “safe” way , the other way if there is some type of ERROR, I can catch it, and remain “safe”