CreateSchema
Generates a schema file from the metadata of a specified table or view. The generated file is exposed by the driver as a new queryable table. The generated file can be edited to customize column names, data types, and other metadata for the generated table.
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 driver 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 driver.
Input
| Name | Type | Required | Description |
| TableName | String | True | The name of the table or view whose metadata is used to generate the schema file. |
| FileName | String | False | The name of the schema file to generate. The file is written to the path specified by the Location connection property. Once created, the driver exposes a new table with this name. |
Result Set Columns
| Name | Type | Description |
| FileData | String | Base64-encoded content of the generated schema, returned if FileName and FileStream are not set. |
| Result | String | Indicates whether the schema generation was successful or failed. |