db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrnap <my...@Golux.Com>
Subject Re: SHOW TABLES equiv.
Date Tue, 11 Jan 2005 03:29:14 GMT
SD wrote:

> Hello, I'm changing our current project from Mysql to use 
> Cloudscape/Derby.
>
> I'm having trouble locating the SQL/commands to list the tables that 
> are currently in the Cloudscape/Derby db.
>
> In Mysql I use "SHOW TABLES".
>
> What is the equivalent sql/command for Cloudscape/Derby?
>
> BTW I've tried selecting on SYSTABLES but the SYSTABLES table doesn't 
> exist.
>
> Thank you in advance.
>
> SD.
>
It's in a schema called sys, i.e.:

    select * from sys.systables

Myrna

Mime
View raw message