How can I list all tables in a database with Squirrel SQL?

database-administration database-table squirrel-sql database-management
Jonas picture Jonas · Feb 4, 2011 · Viewed 40k times · Source

I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries.

But how can I list all tables in the database? And preferably all column and column types.

Answer

k427h1c picture k427h1c · May 6, 2011

Sometimes I noticed that doing the above may not result in the tables showing. Before I figured this out, my table node will not be expandable and I can never get a list of the tables.

After a lot of searching on the internet, I learnt that you need to choose the schema from the catalog drop down box located at the upper left portion of the squirrel sql client before the icons to be able to get the table list for that particular schema.

Hope that helps.

Related questions

How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More
Find out the history of SQL queries

An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL query?

Read More
extract date only from given timestamp in oracle sql

The following query: select cdate from rprt where cdate <= TO_CHAR(sysdate, 'YYYY/MM/DD-HH24-MI-SS-SSSSS') and ryg='R' and cnum='C002'; return: 2013/04/27-10:06:26:794 as stored in the table. I want to get the date only as : 27-04…

Read More