>Hi,
>
>I have a program that connects to an ODBC Data Source, and performs some functions. Please, assume the following code fragment below:
>

> cSQLDataSource = "xyz"
> cSQLUserId     = "xyz"
> cSQLPassword   = "xyz"
>
> nPecasHandle = SqlConnect (cSQLDataSource, cSQLUserId, cSQLPassword)
>
> SqlTables (nPecasHandle, "Table", "TmpTables")
>
> Select TmpTables
> Browse
>
> SqlDisconnect (nPecasHandle)
>

>
>In all my DSNs till now (Informix, Oracle and VFP) when I call SqlTables () it creates a cursor with field names as defined in the help file:
>

>TABLE_QUALIFIER Table qualifier identifier
>TABLE_OWNER     Table owner identifier
>TABLE_NAME      The table name as it appears in the data dictionary
>TABLE_TYPE      The table type as it appears in the data dictionary
>REMARKS         A description of the table
>

>But now, when I accessed a SQL Server 2000 database, it returned:
>

>TABLE_CAT   Character 128
>TABLE_SCHEM Character 128
>TABLE_NAME  Character 128
>TABLE_TYPE  Character 32
>REMARKS     Character 254
>

>There is a reason (or explanation) for that? I'm running a VFP 6.0 SP5 app in a win2k professional.
>
>Thanks in advance.
>
>Fernando

Fernando,
As a workaround you could use sp_tables :

SQLEXEC(lnHandle,[Use pubs ; Exec sp_tables @table_type = "'TABLE'"],'pubs_tables')

Cetin