db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yves pielusenet <yvespieluse...@free.fr>
Subject Retreive colummn name of a table from java
Date Thu, 14 Sep 2006 22:07:55 GMT
Hello,
I read this :
http://wiki.apache.org/db-derby/ListTableColumns

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 ?

thanks,

-- 
yves piel



Mime
View raw message