CreateSchema
Generates a schema file for a specified table or view, useful for integration or development purposes.
Stored Procedure-Specific Information
To execute this procedure, enter:
EXEC CreateSchema TableName='Issues', FileName='C:\\schemas\\Issues.rsd'
Input
| Name | Type | Required | Accepts Output Streams | Description |
| TableName | String | True | False | The name of the table or view for which the schema file should be generated. |
| FileName | String | False | False | The full file path and name where the schema file should be saved. For example: 'C:\\Users\\User\\Desktop\\SmartSheet\\sheet.rsd'. |
| FileStream | String | False | True | A stream object to which the schema file data will be written. Used only when FileName is not specified. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema generation was successful. Returns 'Success' or 'Failure'. |
| FileData | String | The content of the generated schema file, encoded in Base64. This is returned only when neither FileName nor FileStream is specified. |