>>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'
>
Thanks Sergey!
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright