db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathy Saunders <ka...@Source-Zone.com>
Subject Re: SHOW TABLES equiv.
Date Tue, 11 Jan 2005 16:59:27 GMT
myrnap wrote:

> 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
>
>
You can also use the dblook utility to dump the schema.

Kathy

Mime
View raw message