Using Sqlite3 in ruby on rails and cmd

Did you create the table originally via a migration?

You should avoid directly manipulating the database and use migrations instead. If you forgot to add a column then you should create a new migration using add_column to add the column to the table.

Alternativly if the previous migration was the one that created the table with the missing column and you’ve not distributed this migration yet you can do rake db:rollback, editing the migration and run rake db:migrate again.

Your lack of tables when running the sqlite command is most likely because you forgot to specify the sqlite file to load: sqlite3 <db_name>