Database objects are components of a database and can be operated and used through SQL statements. This topic provides an overview of the supported types of database objects and their storage methods in the MySQL-compatible mode of OceanBase Database. Additionally, it explores the relationships and dependencies between these objects.
The database objects supported in the MySQL-compatible mode of OceanBase Database include tables, views, indexes, partitions, sequences, triggers, and stored procedures.
Authorized users in the MySQL-compatible mode of OceanBase Database can access the database and access or manage database objects. A database is a collection of database objects that is used for privilege management and namespace isolation. A schema is a synonym for a database. In SQL statements, the keyword SCHEMA can be used instead of DATABASE. For example, CREATE SCHEMA can be used instead of CREATE DATABASE.