Show fields

[Ivan Smahin]

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)



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com