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