>>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
>>

>
>Thanks Doctor Cetin Basoz for helping but
>your codes displays this error message
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'at20.INFORMATION_SCHEMA.Tables'.
>
>but when I run the following code in sqlserver management query then it work fine as shown in attached image
>

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

>
>Please

My bad:

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