Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Mon, 21 Jan 2008 08:37:50 +0100
From: =?ISO-8859-1?Q?J=F8rgen_L=F8land?= <Jorgen.Loland@Sun.COM>
Subject: Re: Finding object type
In-reply-to: <6b47fb310801190013u50ec923fxb64a2d9cab5bbe55@mail.gmail.com>
Sender: Jorgen.Loland@Sun.COM
To: derby-dev@db.apache.org
Message-id: <47944BCE.7050903@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 8BIT
References: <6b47fb310801190013u50ec923fxb64a2d9cab5bbe55@mail.gmail.com>
User-Agent: Thunderbird 2.0.0.4 (X11/20070622)

> Is there a function in the derby source code to find the type of an object..
> 
> i.e. if the XXX is a table , it should return 'TABLE' ..
> if YYY is a view, it should return 'VIEW'..
> or anything like that??
> 
> please tell where to look for it..
> please help asap...

Hi Jazarine,

Would it be possible to use JDBC in your case? If so, you could e.g. 
have a look at DatabaseMetaData.getTables (check out the Java API). If 
that is not an option, you may write a query like the one below to get 
all non-system tables and views.

select tablename, tabletype from sys.systables where tabletype not like 'S';

A tabletype of "T" is a normal table, while "V" means view.

These methods should work if you want to find the table type from an 
application using Derby. If you want to find the tabletype *inside 
Derby* (because you modify the source code), I would start looking at 
org.apache.derby.client.am.DatabaseMetaData#getTables and find out what 
happens there.

Hope this helps
-- 
J�rgen L�land