Database objects are essential components of a database, including tables, indexes, views, triggers, and sequences. OceanBase Database provides database object management capabilities based on its compatibility with both MySQL and Oracle-compatible modes.
This chapter describes the operations of the following database objects:
Database Object Type |
Supported Mode |
Database Object Management Description |
|---|---|---|
| Database (Database) | MySQL-compatible mode | Describes how to create, view, modify, and delete databases. For more information, see Create a database. |
| Table (Table) | MySQL/Oracle-compatible mode | Describes how to create, modify, delete, lock, and clear tables, as well as define column attributes and set constraint types. For more information, see About tables (MySQL-compatible mode) and About tables (Oracle-compatible mode). |
| External Table (External Table) | MySQL/Oracle-compatible mode | Describes how to create external tables, create external table partitions, manage external files, and map data types. For more information, see About external tables (MySQL-compatible mode) and About external tables (Oracle-compatible mode). |
| Partition (Partition) | MySQL/Oracle-compatible mode | Describes how to create, split, and dynamically manage partitions, as well as adjust partition rules, add, and delete partitions. For more information, see Partition overview (MySQL-compatible mode) and Partition overview (MySQL-compatible mode). |
| Table Group (TableGroup) | MySQL/Oracle-compatible mode | Describes how to create, view, add tables, modify SHARDING attributes, and delete table groups. For more information, see About table groups (MySQL-compatible mode) and About table groups (Oracle-compatible mode). |
| Index (Index) | MySQL/Oracle-compatible mode | Describes how to create, view, monitor, and delete indexes, as well as support for function indexes. For more information, see About indexes (MySQL-compatible mode) and About indexes (Oracle-compatible mode). |
| View (View) | MySQL/Oracle-compatible mode | Describes how to create, modify, and delete normal views. For more information, see Manage normal views (MySQL-compatible mode) and Manage normal views (Oracle-compatible mode). |
| Materialized View (Materialized View) | MySQL/Oracle-compatible mode | Describes how to create, refresh, query rewrite, modify attributes, and isolate resources for materialized views. For more information, see Materialized views overview (MySQL-compatible mode) and Materialized views overview (Oracle-compatible mode). |
| Sequence (Sequence) | MySQL/Oracle-compatible mode | Describes how to create, view, modify, and delete sequences. For more information, see Create a sequence (MySQL-compatible mode) and Manage sequences (Oracle-compatible mode). |
| Trigger (Trigger) | MySQL/Oracle-compatible mode | Describes how to create, view, and delete triggers. For more information, see Overview (MySQL-compatible mode) and Overview (Oracle-compatible mode). |
| DBLink (database link) | MySQL/Oracle-compatible mode | Describes how to create, view, and delete a DBLink. For more information, see Create a DBLink (MySQL-compatible mode) and Create a DBLink (Oracle-compatible mode). |
| Catalog (data catalog) | MySQL-compatible mode | Describes how to create, view, and delete a catalog. For more information, see Overview of Catalog. |
| Synonym | Oracle-compatible mode | Describes how to create and delete a synonym. For more information, see Manage synonyms. |
| Directory | Oracle-compatible mode | Describes how to create and delete a directory. For more information, see Manage directories. |