Creates a schema file for the specified Sage X3 Cloud table or view.

Stored Procedure-Specific Information

To generate a schema file for a Sage X3 Cloud table or view, specify the table name and an output file path:

    EXEC CreateSchema TableName='ABANK', FileName='C:\MyFolder\ABANK.rsd'

To generate a schema file for a table in a specific Sage X3 folder (schema), set the SchemaName input:

    EXEC CreateSchema TableName='ABANK', SchemaName='SEED', FileName='C:\MyFolder\ABANK.rsd'

If FileName is not specified, the generated schema is returned as a base64-encoded value in the FileData output column.

Input

Name	Type	Accepts Output Streams	Description
TableName	String	False	The name of the table or view to generate a schema for.
SchemaName	String	False	The name of the schema (Folder) the table or view belongs to. Defaults to the schema of the current connection.
FileName	String	False	The full file path and name of the schema to generate. Ex : 'C:\\Users\\User\\Desktop\\SageX3Cloud\\ABANK.rsd'. If not set, the FileData output is used instead.
FileStream	String	True	An instance of an output stream where the file data is written to. Only used if the FileName input is not set.

Result Set Columns

Name	Type	Description
Result	String	Returns Success or Failure.
FileData	String	If the FileName and FileStream inputs are not set, this output holds the generated schema encoded in base64.