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

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

-------- Original Message --------
Subject: Re: xxx$db$tables
Date: Mon, 25 Oct 1999 08:54:22 +0100
From: martin.husted@notes.electrolux.dk
To: instantdb@smartcard.co.uk

Hey Peter,

Very nice, and one can even use tableNamePattern to get tables with
specific
name patterns, just what
I was looking for, I did'nt even bare a hope in finding such a thing.
Thanks a
lot for the help Peter.

Greetings
Martin





"Peter Hearty" <peter.hearty@ceasar.demon.co.uk> on 22-10-99 16:47:36

To:   instantdb@smartcard.co.uk
cc:
Subject:  Re: xxx$db$tables




Martin

>Is this boundary between system and user tables the only way to separate to
two
>types of tables?

Not quite. You could use DatabaseMetaData.getTables. It has a final
field
String[] types. InstantDB recognises the types TABLE and SYSTEM TABLE
which
allows you to distinguish between the two.





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