zumero

No such table in ZSS Test Client window

Using the Test Client, I get a "No Such Table" error when trying to select some data from my database - sync was successful.

Here's my query: select * from schema.TableName.

Solution

  • Try with:

    SELECT * FROM TableName

    i.e. without the schema name in front

    Or, if the table was from a schema other than dbo, it will be prefixed by the schema name + _ (see SQL Server Schemas in the ZSS Manager docs). So if the original table was MySchema.TableName, you'd use:

    SELECT * from MySchema_TableName