SqlDbx
You are not logged in.
I've got some MS 2016 SQL Databases that have a schema assigned other than the default dbo. When I query those databases using SQLDBX Pro 5.11 I receive an error. For example, if I query the Wide World Importers sample db table External Sales.Cities I receive the message:
Invalid object name 'WideWorldImporters.External Sales.Cities' .. Error 208. SQLSTATE 42S02. Severity 16. MsgState 1. Line 1.
The database works as expected if using Microsoft's SQL Server Management Console.
This issue seems to arise in other databases which have assigned a schema.
The other interesting issue in this particular database is that SQLDBX doesn't seem to be able to see all of the tables. All of the tables in the sample db are visible in the Microsoft tooling, but are not visible in SQLDBX.
Offline
Hi. Try using this name.
[WideWorldImporters].[External Sales].[Cities]
Cheers,
Offline