# 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](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/list-databases.html.md) | List the databases you have access to. |
| [Inspect tables and views in a database](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/list-database-tables.html.md) | View tables and views in a database. |
| [Inspect table definition and row count](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/get-table-info.html.md) | Inspect table column definitions and row count without returning data rows. |
| [Inspect column types and constraints](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/list-table-columns.html.md) | View the table's field names, types, whether null values are allowed, default values, and key types. |
| [Retrieve an object definition](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/get-table-ddl.html.md) | View the create statement for the table or view. |
| [Remove database](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/delete-database.html.md) | Delete the specified database. |
| [Remove table](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/delete-table.html.md) | Delete the specified table. |
| [Remove view](https://omnifabric.cloudsigma.com/docs/reference/api/ai-studio/data-processing/sql-metadata/delete-view.html.md) | Delete the specified view. |