Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

.schema won't show tables in SQLite3

4 views
Skip to first unread message

nir

unread,
Dec 2, 2012, 4:08:58 AM12/2/12
to
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
0 new messages