InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Nathan

Try something like:

c get columns mytables% %;

Regards

Peter Hearty
Lutris Technologies UK


-----Original Message-----
From: owner-instantDB@enhydra.org [mailto:owner-instantDB@enhydra.org]On
Behalf Of Nathan Cook
Sent: 14 November 2000 20:24
To: instantDB@enhydra.org
Subject: Re: InstantDB: Describe DB


Mr. Hearty-
    I may have made a mistake, but when I run the below sql1.txt I get the
output below.  Do you know of any commands that would describe a table or
database with the fields and field types?

Thank You!
Nathan Cook

--- Contents of SQL1.TXT ---
d org.enhydra.instantdb.jdbc.idbDriver;
o jdbc:idb=/home/SocratEase/Server/eudb.prp;

e SET EXPORT "export0.txt" FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL
SUMMARYHEADER;
c all tables;
c close;


--- When I run Startscript tool I get the following output ---
[root@lyceum webserver]# ./startscripttool
Enhydra InstantDB - Version 3.21
The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
Inc.
All Rights Reserved.

Connected to jdbc:idb:/home/SocratEase/Server/eudb.prp
Driver   InstantDB JDBC Driver
Version  Version 3.21

TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,TABLE_REMARKS
,,$db$types,SYSTEM TABLE,
,,COURSES$pKey,SYSTEM TABLE,
,,COURSE_ENROLLMENTS$pKey,SYSTEM TABLE,
,,COURSE_LOCK$pKey,SYSTEM TABLE,
,,EXAM_ENTRIES$pKey,SYSTEM TABLE,
,,GRADES$pKey,SYSTEM TABLE,
,,LESSONS$pKey,SYSTEM TABLE,
,,LOCALES$pKey,SYSTEM TABLE,
,,MAIL_MESSAGES$pKey,SYSTEM TABLE,
,,QUESTIONS$pKey,SYSTEM TABLE,
,,SECTIONS$pKey,SYSTEM TABLE,
,,SEQUENCE$pKey,SYSTEM TABLE,
,,SUBJECTS$pKey,SYSTEM TABLE,
,,TEMPLATES$pKey,SYSTEM TABLE,
,,THEMES$pKey,SYSTEM TABLE,
,,UNITS$pKey,SYSTEM TABLE,
,,USERS$pKey,SYSTEM TABLE,
,,eudb$db$Cols,SYSTEM TABLE,
,,eudb$db$Cols$pKey,SYSTEM TABLE,
,,eudb$db$Indexes,SYSTEM TABLE,
,,eudb$db$Tables,SYSTEM TABLE,
,,eudb$db$Tables$pKey,SYSTEM TABLE,
,,COURSES,TABLE,
,,COURSE_ENROLLMENTS,TABLE,
,,COURSE_LOCK,TABLE,
,,COURSE_SUBJECTS,TABLE,
,,EXAM_ENTRIES,TABLE,
,,GRADES,TABLE,
,,LESSONS,TABLE,
,,LOCALES,TABLE,
,,MAIL_MESSAGES,TABLE,
,,MANAGERS,TABLE,
,,QUESTIONS,TABLE,
,,SECTIONS,TABLE,
,,SEQUENCE,TABLE,
,,SUBJECTS,TABLE,
,,TEMPLATES,TABLE,
,,TEMPLATE_COURSES,TABLE,
,,THEMES,TABLE,
,,UNITS,TABLE,
,,USERS,TABLE,
,,sub_mail_mailbox,TABLE,
Database eudb is shutting down...
Database eudb shutdown complete.
-----------------------------------------------------------
----- Original Message -----
From: Peter Hearty <peter.hearty@lutris.com>
To: <instantDB@enhydra.org>
Sent: Thursday, November 02, 2000 8:55 AM
Subject: Re: InstantDB: Describe DB


> Nathan
>
> Try any of:
>
> c show meta-data;
> c system tables;
> c ordinary tables;
> c all tables;
>
> Other metadata commands can be found by looking in ScriptTool.java in the
> Examples directory or by referring to
>
>
http://instantdb.enhydra.org/software/documentation/sample-applications.html
> #scriptool
>
> Regards
>
> Pete
>
> --
>
> Peter Hearty                         peter.hearty@lutris.com
> Lutris Technologies (UK)        http://www.lutris.com
> ----- Original Message -----
> From: "Nathan Cook" <ncook@pcsedu.com>
> To: <instantDB@enhydra.org>
> Sent: Tuesday, October 31, 2000 5:57 PM
> Subject: InstantDB: Describe DB
>
>
> Is there a command that I can put into sql1.txt for startscripttool to
> describe tables, or database, with field names and information?
>
> Thank You,
> Nathan Cook
> ncook@pcsedu.com
>
>
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

----------------------------------------------------------------------------
-
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.