CreateSchema
Generates a schema definition file for a specified SharePoint table or view, aiding in documentation.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC CreateSchema TableName='MyTable'
Input
| Name | Type | Required | Description |
| TableName | String | True | Name of the SharePoint table or view for which the schema should be generated. |
| FileName | String | 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'. |
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. |