>I have a connection to a SQL Server database. When I go in to create a remote view everything works fine, but there are a hundred or so tables. I want my program to create SQL remote views for all the tables in the connection but I can't figure out how to programatically determine the table names. Any ideas?
>
>TIA
>
>Leighton

Leighton,

Try SQLTABLES(). It should create a cursor that has one row for each table in the database.

-Mike