create_view
Generate a database view by defining its name and SQL query. Simplify data access and management in CockroachDB through structured views.
Instructions
Create a view from a specific query.
Args: view_name (str): Name of the view. query (str): SQL query for the view definition.
Returns: A success message or an error message.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| view_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"query": {
"title": "Query",
"type": "string"
},
"view_name": {
"title": "View Name",
"type": "string"
}
},
"required": [
"view_name",
"query"
],
"title": "create_viewArguments",
"type": "object"
}