Show fields

[Bart Pietercil]

Perfect, thx

Bart


On 15-okt-07, at 16:00, Ivan Smahin wrote:

> Hello Bart,
>
> Monday, October 15, 2007, 4:48:06 PM, you wrote:
>
>> Hi List,
>
>> This query returns a cursor with the schema of a table
>
>> show fields (or columns) of tbl_a
>
>> The cursor is build with multiple columns. Now I am only interested
>> in the name column. Is there a way to query that the cursor has only
>> the name field?
>
>> something like
>
>> show field('name') of tbl_a
>
> SELECT name FROM (SHOW FIELDS of tbl_a)
>