Ok - Yves, can you try against the schema 'APP' (default) such as:

ij> select columnnumber, columnname, columndatatype
   from sys.systables t, sys.syscolumns, sys.sysschemas s
   where tableid=referenceid and t.schemaid=s.schemaid
     and schemaname='APP' and tablename='DATA'
   order by columnnumber;

On 9/14/06, yves pielusenet <yvespielusenet@free.fr> wrote:
Yes I have tried it but there is any rows back :(

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;
COLUMNNUMB&|COLUMNNAME|COLUMNDATATYPE
------------------------------------------------------------------------------------------------------------------------------------------------------------

0 lignes sélectionnées


Le jeudi 14 septembre 2006 à 15:37 -0700, Francois Orsini a écrit :
> Have you tried the following below?
>
> 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;
>
> are you getting any rows back?
>
> On 9/14/06, yves pielusenet <yvespielusenet@free.fr> wrote:
>         after tests I found this statement :
>         ij> select columnname, columnnumber from sys.systables,
>         sys.syscolumns where referenceid=tableid and tablename='DATA'
>         order by columnnumber;
>
>         which works well for me :)
>
>         do you see something wrong ?
>
>
>         Le jeudi 14 septembre 2006 à 15:16 -0700, Francois Orsini a
>         écrit :
>         > Yes,
>         >
>         > It all depends how you created the table - have you tried
>         running the
>         > query by specifying you table name in uppercase such as:
>         > j> 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;
>         >
>         > _or_ you can also run "select * from sys.systables" and find
>         out if
>         > your table appears in the list being retrieved...then check
>         the actual
>         > table identifier (aka name)...
>         >
>         > Hope this helps a bit,
>         >
>         > --francois
>         >
>         > On 9/14/06, yves pielusenet <yvespielusenet@free.fr> wrote:
>         >         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
>         >
>         >
>         >
>
>