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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: xxx$db$tables and more ...


Bregitte

A good way to do this is to switch logging on in your database by setting
traceLevel=2 in the properties file. You can then experiment by making
DatabaseMetaData.getColumns calls and watching the SQL that InstantDB
generates for them. You can then cut and paste the SQL.

Regards

Peter Hearty
Instant Computer Solutions
-----Original Message-----
From: Bregitte Pracht <bpracht@nortelnetworks.com>
To: instantdb@smartcard.co.uk <instantdb@smartcard.co.uk>;
peter.hearty@ceasar.demon.co.uk <peter.hearty@ceasar.demon.co.uk>
Date: 29 October 1999 14:00
Subject: xxx$db$tables and more ...


>Hi,
>
>I have a question somewhat related to this topic.
>
>I am interested in determining the user-defined tables and their
>fields and fieldtypes while using SQL only (not DatabaseMetaData).
>To determine the user-defined tables I do this:
>
> select TableName from xxx$db$Tables
>                           where TableID > 1005 and Type = 1
>
>Once I have the user-defined table names, how can I determine
>the fields (and associated fieldtypes) a given table contains?
>
>Thanks,
>Bregitte


To unsubscribe from this list, please an send
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.