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	Page	Description
Find accessible databases	View database list	List the databases you have access to.
Inspect tables and views in a database	View tables and views in a database	View tables and views in a database.
Inspect table definition and row count	View table information	Inspect table column definitions and row count without returning data rows.
Inspect column types and constraints	View table column list	View the table’s field names, types, whether null values are allowed, default values, and key types.
Retrieve an object definition	View table or view creation statement	View the create statement for the table or view.
Remove database	Delete database	Delete the specified database.
Remove table	Delete table	Delete the specified table.
Remove view	Delete view	Delete the specified view.

Last updated on Oct 19, 2026