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') >0but it shows nothing