Skip to main content

Schema Inspection

CamusDB supports SQL inspection commands for databases, tables, columns, indexes, and query plans.

Databases​

SHOW DATABASES;
SHOW DATABASE;

SHOW DATABASES lists registered databases. SHOW DATABASE reports the current database context.

Tables And Columns​

SHOW TABLES;
SHOW COLUMNS FROM robots;
DESCRIBE robots;
DESC robots;
SHOW CREATE TABLE robots;

Indexes​

SHOW INDEXES FROM robots;
SHOW INDEX FROM robots;

Explain​

Inspect a plan with EXPLAIN:

EXPLAIN SELECT * FROM robots WHERE year = 2024;
EXPLAIN (LOGICAL) SELECT * FROM robots WHERE year = 2024;
EXPLAIN (PHYSICAL) SELECT * FROM robots WHERE year = 2024;
EXPLAIN (ANALYZE) SELECT * FROM robots WHERE year = 2024 LIMIT 5;

See Explaining Queries And Commands for output details.