Re: Retreive colummn name of a table from java

[Thomas Kellerer]

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