CreateSchema
Creates schema definitions for tables in Oracle Fusion Cloud SCM, enabling database management.
CreateSchema
Creates a local schema file (.rsd) from an existing table or view in the data model.
The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.
The provider checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the provider.
Input
| Name | Type | Accepts Output Streams | Description |
| TableName | String | False | The name of the table for which the schema is being generated. This helps identify the specific table for schema creation. |
| SchemaName | String | False | The name of the schema that contains the table. This provides the context for where the table resides within the database structure. |
| FileName | String | False | The full file path and name where the schema will be saved. For example, 'C:\\scripts\\Accounts.rsd' specifies the location and file name for the generated schema. |
| SimplifyNames | String | False | Flag indicating whether to use simplified names for columns in the schema. If set to 'true', longer or more complex column names are shortened for ease of use. Default behavior is to simplify names. |
| FileStream | String | True | Output stream used to write the generated schema data directly. This is only returned if a file path (FileName) is not provided, allowing the schema to be handled as a stream. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema was successfully generated and downloaded. A value of 'true' means the process completed successfully, while 'false' indicates an error or failure. |
| FileData | String | The generated schema encoded in Base64 format, returned when both FileName and FileStream are not set. This provides the schema in a data format that can be decoded and saved. |