>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