Adapter Online Help > TDV Cosmos DB Adapter > Stored Procedures
 
Stored Procedures
Stored procedures are available to complement the data available from the NoSQL Database. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
Cosmos DB Adapter Stored Procedures
Name
Description
Creates a schema file for the collection.
CreateSchema
Creates a schema file for the collection.
Input
Name
Type
Description
SchemaName
String
The schema of the collection.
TableName
String
The name of the collection.
FileName
String
The full name of the generated schema.
Result Set Columns
Name
Type
Description
Result
String
Returns Success or Failure.