>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'