Generates a schema definition file for a specified SharePoint table or view, aiding in documentation.

Stored Procedure-Specific Information

The CreateSchema stored procedure generates an RSD schema file for a SharePoint table. You can output the schema to a file using the FileName parameter, or retrieve the schema content as base64-encoded data using the FileData output.

To generate a schema file and save it to disk, enter:

EXEC CreateSchema TableName = 'MyList', FileName = 'C:\schemas\MyList.rsd';

To retrieve the schema content as base64-encoded data, omit the FileName parameter:

EXEC CreateSchema TableName = 'MyList';

Input

Name	Type	Required	Accepts Output Streams	Description
TableName	String	True	False	Name of the SharePoint table or view for which the schema should be generated.
FileName	String	False	False	Full path and filename where the generated schema (.rsd) file will be saved. The path should include the parent directory, schema folder (SharePoint), and the .rsd filename. For example: 'C:\\Users\\User\\Desktop\\SharePoint\\SharePoint\\SOAP\\sheet.rsd'.
FileStream	String	False	True	Output stream instance used to write the schema file. Only applicable if FileName is not specified.

Result Set Columns

Name	Type	Description
Result	String	Indicates the status of the operation, returning either Success or Failure.
FileData	String	Schema file content encoded in Base64, returned only if FileName and FileStream are not provided.