Database objects are essential components of a database, including tables, indexes, views, triggers, sequences, and more. OceanBase AI Database provides database object management capabilities based on its MySQL-compatible mode.
This chapter describes the operations of the following database objects:
Database object type |
Database object management description |
|---|---|
| Database | This topic describes how to create, view, modify, and drop databases. For more information, see Create a database. |
| Table | This topic describes how to create, modify, drop, lock, and truncate tables, as well as define column attributes and set constraint types. For more information, see About tables. |
| External Table | This topic describes how to create external tables, create partitions of external tables, manage external files, and perform data type mappings. For more information, see External tables and external files. |
| Partition | This topic describes how to create, split, and manage dynamic partitions of a partitioned table, as well as adjust partitioning rules and add or drop partitions. For more information, see Partitioning overview. |
| TableGroup | This topic describes how to create, view, add tables to, modify the SHARDING attribute of, and delete a table group. For more information, see About table groups. |
| Index | This topic describes how to create, view, monitor, and drop indexes, as well as the support for function-based indexes. For more information, see About indexes. |
| View | This topic describes how to create, modify, and drop normal views. For more information, see Manage regular views. |
| Materialized view | This topic describes how to create, refresh, query rewrite, modify the properties of, and perform resource isolation on materialized views. For more information, see Overview of materialized views. |
| Sequence | This topic describes how to create, view, modify, and drop sequences. For more information, see Create a sequence. |
| Trigger | This topic describes how to create, view, and drop triggers. For more information, see Overview. |
| DBLink | This topic describes how to create, view, and delete DBLinks. For more information, see Create a DBLink. |
| Catalog | This topic describes how to create, view, and delete a catalog. For more information, see Overview of Catalog. |
| Hot Cache Policy (storage_cache_policy) | This topic describes how to create, modify, and maintain a hotspot cache policy. For more information, see Overview of custom hotspot cache policies. |