Table Description 1

[karlsruhe]

Hi all,
i have a simple question! Is there a command for the sqlbase database which displays the table description?

Something like the DESC command in oracle and mssql or SHOW in mysql?!

Many Thanks In Advance
S+

 

[ModelTrains]

SELECT * FROM SYSCOLUMNS WHERE TBNAME='tablename';