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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
>
>
>
