Could you add a command to list all tables in the database?
For example, we can use ".tables" in sqlite3.exe to list all the tables.
For now, i use the following SQL statements to list tables:
- SQL Server: select name from sysobjects where xtype='U';
- SQlite3: SELECT name FROM sqlite_master WHERE type='table';
It would be nice if the command to display the column structure was also available. Such as Oracle's "describe" command.