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: [EMAIL PROTECTED] Sun Microsystems Inc. phone: (781) 442-2037 1 Network Drive, UBUR02-301 fax : (781) 442-1610 Burlington, MA 01803
