>Hi,
>
>What is the syntax of command to pass to SQL Server from VFP that would allow me to get all tables of the database and for each table all fields/columns? TIA.
Take a look at the INFORMATION_SCHEMA.Tables system view and also INFORMATION_SCHEMA.Columns.
INFORMATION_SCHEMA.TABLES has all tables and views in the database and the INFORMATION_SCHEMA.Columns has information about all columns in every table in a database.
If it's not broken, fix it until it is.
My Blog