Cancel an EXCLUDE SCHEMA statement with INCLUDE to restore datasource schemas for SQL statements.

View Excluded Schemas

  • View all excluded Schemas

select * from sys.SYSEXCLUDEDSCHEMAS

Syntax

INCLUDE schemaname ON datasource;

Arguments

  • schemaname - the name of the schema.

  • datasource - the datasource containing the schema.

Examples


INCLUDE inventory ON MySQL1;
INCLUDE inventory ON MySQL 1;

See Also