Utility Commands

Utility Commands are specialized instructions that don’t fit neatly into the standard data query or manipulation categories.

Instead of dealing with business data, utility commands are generally used to introspect the database itself (metadata), understand its state, or manage automated background processes.

Metadata & Introspection

These commands allow you to explore the structure and capabilities of your database.

• SHOW TABLES: Lists all tables currently existing in the database.
• SHOW INDEXES: Displays the indexes attached to a specific table.
• SHOW FUNCTIONS: Lists all built-in and user-defined functions available to use in queries.
• SHOW CREATE TABLE: Outputs the exact DDL statement required to recreate a specific table.
• INFORMATION_SCHEMA: A deep dive into the standard set of virtual tables (like information_schema.columns) that you can query using SELECT to programmatically analyze your schema.

Background Job Scheduling

Oxibase has a built-in cron-based task runner for executing stored procedures automatically in the background.

• CREATE SCHEDULE: Registers a new automated task.
• ALTER SCHEDULE: Pauses, resumes, or changes the frequency of an existing task.
• DROP SCHEDULE: Removes a background task entirely.

---

Table of contents

• ALTER SCHEDULE
• CREATE SCHEDULE
• DROP SCHEDULE
• INFORMATION_SCHEMA
• SHOW CREATE TABLE
• SHOW FUNCTIONS
• SHOW INDEXES
• SHOW TABLES