I assume you are talking to SQL Server. If that is the case I don't think you will see performance decrease as the table grows.

FWIW, here is another way of getting the structure of your table

set fmtonly on
select * from mytable
set fmtonly off

I don't know if this will increase/decrease performance. But if you open a view with NODATA this is what VFP send to SQL Server.


>Hi All,
>
>Can someone please tell me whether the following query (using SQL pass-through) would take long time if the table grows into millions?
>
>=SQLExec(nMyHandle, "SELECT * FROM mytable WHERE 1=2", "mycursor")
>
>Actually what I want was the exact structure of back-end table and that is why I put a false WHERE clause.
>
>Or is there another way to get the table structure into array or cursor?
>
>Thanks for your time.
>
>Regards
>Vijay