Query to retrieve 'COLUMN' names in a table

[raseena nm]

hi,
Can anybody tell me how to write a query to retrieve all the column names of a table?
thanx.

[SJ Adnams]

select cname from col where tname = 'mytable ';
they will also be in the metadata.

[raseena nm]

thanx