db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lance Andersen <Lance.Ander...@Sun.COM>
Subject Re: SHOW TABLES equiv.
Date Tue, 11 Jan 2005 18:46:06 GMT
I do think it would be useful to add a feature to derby similar to 
sp_help/describe.



Kathy Saunders wrote:
> 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


-- 
Lance Andersen                       email: Lance.Andersen@sun.com
Sun Microsystems Inc.                phone: (781) 442-2037
1 Network Drive, UBUR02-301          fax  : (781) 442-1610
Burlington, MA 01803


Mime
View raw message