On 12/5/05, Paul Bohme <[EMAIL PROTECTED]> wrote: > 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?)
Yeah, I just didn't see the new column because it appeard on the same line with one of the other columns. Sorry for the trouble... Aaron