>Thanks sir, your codes work fine
>
>Now I have these codes
>
>

>SELECT TABLE_NAME FROM at20.INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'
>

>
>Above codes work fine in sqlserver management query but I am trying to convert these in vfp like this
>
>

>If SQLExec(m.con1, "SELECT TABLE_NAME FROM concat([<<m.db1>>],'.',INFORMATION_SCHEMA.Tables) WHERE TABLE_TYPE = 'BASE TABLE'",'tablist') >0
>

>
>but it shows nothing
>I want to replace at20 from variable m.db1
>
>Please

You cannot use concat() for a table name.

If SQLExec(m.con1, textmerge("SELECT TABLE_NAME"+;
 " FROM [<<m.db1>>.INFORMATION_SCHEMA.Tables]"+;
 " WHERE TABLE_TYPE = 'BASE TABLE'"),'tablist') >0