db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Kellerer <spam_ea...@gmx.net>
Subject Re: Retreive colummn name of a table from java
Date Thu, 14 Sep 2006 22:11:15 GMT
yves pielusenet wrote on 15.09.2006 00:07:
  > but I can't retreive the column of my table 'data'. Here is what i
> tested :
> ij> select columnnumber, columnname, columndatatype
>     from sys.systables t, sys.syscolumns, sys.sysschemas s
>     where tableid=referenceid and t.schemaid=s.schemaid
>       and schemaname='SYS' and tablename='data'
>     order by columnnumber;
> 
> And the result is :
> 
> COLUMNNUMB&|COLUMNNAME|COLUMNDATATYPE
> ------------------------------------------------------------------------------------------------------------------------------------------------------------
> 
> 0 lignes sélectionnées
> 
> How can I do ?

Tablenames are stored in upper case, so it should be tablename = 'DATA' if I'm 
not mistaken.

Regards
Thomas


Mime
View raw message