Re: [sqlite] updating .schema after ALTER TABLE

[Paul Bohme]

Aaron Peterson wrote:

I added a column to a table with ALTER TABLE.  I'm sure it worked as
expected since trying to add it again produces an error that the
column already exists.  However, .schema doesn't show the new column.
Is there some other command that shows all current columns?
Is there a way to update the information shown by .schema?
 


Did you close and re-open the database?  (Perhaps close sqlite3 and 
relaunch?)

 -P