SELECT * FROM USER_TAB_COLUMNS WHERE Table_Name = 'MyTable'

>Sergey
>
>Looks like they both do not work for Oracle. Any other ideas?
>
>>>Anyone know a way to retrieve all the column names from a sql table that has more columns than VFP9 or earlier can return in sqlcolumns()?
>>
>>John,
>>
>>You can use sp_columns system stored procedure or INFORMATION_SCHEMA view

SELECT * FROM pubs.INFORMATION_SCHEMA.COLUMNS
>>	WHERE table_name = 'authors'
>>