>But you said you're prefacing the views with "V_". That makes the view name not the same as the table name???

Thanks for your response. Sorry to be unclear.

The first question comes up because I am considering naming the remote views with the same name as their base SQL Server tables. In the past I have named views with the name of the SQL Server table preceded by "V_". So the first question is: are there any circumstances when VFP will get confused by the view having the same name as the underlying SQL Server table? I think not, but still wonder.

And I have a second question: in the chance that there was a free table in the current directory with the same name as a view in the current database, which would be opened by USE xxx?

Alex


>>Hi,
>>
>>I am migrating free table data to SQL Server tables using remote views. I've named the remote views the same as the tables with a preceding "V_", but I am wondering if there is any downside to naming the remote views the same as the base tables. Would VFP get confused?
>>
>>Related question: If a DBC containing remote view xxx is open an there is a free table xxx in the current directory, which would be opened by USE xxx?
>>
>>TIA,
>>
>>Alex