>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

SQLCOLUMNS(nMyHandle,"mytable", "FOXPRO | NATIVE", "myresults")