Produces a schema file outlining the structure of the specified table or view, supporting data analysis and integration.

Stored Procedure-Specific Information

To execute this stored procedure and write the schema to a file, enter:

    EXEC CreateSchema TableName='Attendee', FileName='C:\my_output_folder\Attendee.rsd'

To execute this stored procedure and return the schema as FileData, enter:

    EXEC CreateSchema TableName='Attendee'

Input

Name	Type	Accepts Output Streams	Description
TableName	String	False	The name of the table or view for which the schema will be generated. Provide the exact name as it appears in NetSuite.
FileName	String	False	The file name for the generated schema. If no file path is included, the file will be generated in 'Location property' + 'SuiteQL' + 'FileName'. For example, if FileName is set to 'table.rsd', then the file will be generated in '%APPDATA%\\CData\\NetSuite Data Provider\\Schema\\SuiteQL\\table.rsd'
FileStream	String	True	A stream object where the schema file data is written. Used only when the FileName parameter is not provided.

Result Set Columns

Name	Type	Description
FileData	String	The binary content of the generated schema file, returned only if FileName and FileStream are not provided.
Result	String	Indicates whether the schema generation was successful or failed.