Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
You can choose to manually code SQL Schema data source files instead of creating them as you add SQL source to a data view.
Follow these guidelines:
- Create each SQL Schema file in the AMB project\group
SQLSCHEM subdirectory.
- Code a CREATE SUBSCHEMA statement that identifies tables to include.
- The SUBSCHEMA name must match the name of the data view intended to include it.
- Each table referenced in the SUBSCHEMA must be defined in one or more SQL DDL native data source files in the project\group
SQLDDL subdirectory.
- For specific syntax information, see the
CREATE SUBSCHEMA reference topic.