Schema names in SQL connections via the External Data Source, Table Control and SQL connectors default to dbo.
Where database schemas are otherwise specified, as shown in the Example below, the fully qualified table name, e.g., HumanResources.Department may be used when connecting to a SQL table using the External Data Source Control, however you can only select the Query option, not the Table option.
Article ID: 747, Created: March 11, 2016 at 4:15 PM, Modified: June 13, 2016 at 2:18 PM