Mark,
Thanks.
>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'
>>>