You can choose to exclude datasource schemas so they are invisible to SQL statements.

View Excluded Schemas

View all excluded Schemas using this SQL statement.

select * from sys.SYSEXCLUDEDSCHEMAS

Syntax

EXCLUDE schemaname ON datasource;

Arguments

  • schemaname - the name of the schema.

  • datasource - the datasource containing the schema.

Examples

EXCLUDE inventory ON MySQL1;
--or
EXCLUDE inventory ON MySQL 1;