.schema won't show tables in SQLite3

[nir]

Hi!
I don't know if this is the right place to post it but I'll give it a try.
System:Ubuntu 12.04
I installed SQLite3 by doing:sudo apt-get install SQLite3
everything went smooth and I soon began using SQL scripts.
The problem is, that when I am on the database engine prompt,
like this:sqlite>
and I issue the command .schema to show my tables, nothing happens and
I simply get the prompt back. The same goes for the .tables command.
Please, if someone encountered this problem and knows how to show the
tables in my sql.files I'll appreciate this greatly.
Thank you in advance
Nir

[Cousin Stanley]

nir wrote:

> ....

> The problem is, that when I am on the database engine prompt,
> like this:sqlite>
>
> and I issue the command .schema to show my tables, nothing happens
> and I simply get the prompt back.
>
> The same goes for the .tables command.

> ....

You may need to either change your working directory
or include the complete path and file name
to the sqlite database file that you originally created
when you start the sqlite3 interpreter ....

$ cd /some/path/to

$ sqlite3 my.db


$ sqlite3 /some/path/to/my.db

If the db path is omitted or incorrect
sqlite3 is working on a blank slate
and no tables are available ....


--
Stanley C. Kitching
Human Being
Phoenix, Arizona