SQLite Forum

sql column in sqlite_master
Login
The sql field normally has the CREATE statement as-is from when it was run with just the opening keywords capitalized. But if you use ALTER TABLE to rename a table or field it will always put the new name in quotes no matter how simple the new name is. (If I'm remembering correctly)

As to why? Ehh, better safe than sorry? <shrugs>