SQL metadata

Use these interfaces to find databases, tables, and views, and then view table fields or table creation statements. The deletion operation is irreversible. Please confirm the target object before execution.

Choose a task

Task

Description

Find accessible databases

List the databases you have access to.

Inspect tables and views in a database

View tables and views in a database.

Inspect table definition and row count

Inspect table column definitions and row count without returning data rows.

Inspect column types and constraints

View the table’s field names, types, whether null values are allowed, default values, and key types.

Retrieve an object definition

View the create statement for the table or view.

Remove database

Delete the specified database.

Remove table

Delete the specified table.

Remove view

Delete the specified view.

Last updated on