Databases

List, inspect, create, update, and delete catalog databases, inspect their objects and tables, or run NL2SQL. Use the database identifier returned by the relevant action for subsequent database operations.

Choose a task

Task

Page

Description

Find catalog databases

Query database list

Returns a list of readable databases under the specified Catalog.

Inspect a database

Query database details

Query database details by ID.

Add a database

Create database

Create a database under the specified Catalog.

Change a database description

Update database

Change the database description; renaming is not supported.

Remove a database

Delete database

Delete a database after confirming that publications and subscriptions do not use it.

Browse database objects

Query objects in the database

Query the volumes, tables and operators that can be read in the specified database.

Find tables in a database

Query database table leaf nodes

Paged query specifies the tables directly contained in the database.

Execute generated SQL

Run NL2SQL

Execute NL2SQL-generated SQL in the specified database and return the result columns and rows.
Last updated on