>Keep in mind my questions are probably very stupid or naive (or both <g>), but I am very ignorant on the subject of SQL Server.
>
>1. If I were to use SqlColumns() (which I just looked up in help, never used it before), I would need to make connection to the SQL Server first, right? This is how I make connection:
>
>

>PUBLIC hCon
>hCon = SQLSTRINGCONNECT([DRIVER=SQL Server;SERVER=
>(local);DATABASE=MyDatabase;Trusted_Connection=Yes])
>

>
>The SqlColumns() has a parameter nStatementHandle. Would this be the same as hCon above?

Yes

>
>2. INFORMATION_SCHEMA is not even in VFP help. So this is strictly SQL Server thingy. Where would I look for syntax on how to use it, that is how to "run a query" against it?
>

You would look in SQL Server Books Online (BOL). It's SQL Server help file, very good one.

SELECT * 
FROM pubs.INFORMATION_SCHEMA.Columns 
WHERE table_name = 'Authors'