Regatta home page
Search...
⌘K
Ask AI
Support
Start Coding
Start Coding
Search...
Navigation
Database Catalog Data
Database Catalog Data
Docs Home
Quickstart
SQL
Regatta Cloud
Self-Hosted Deployment
Drivers & Clients
Tuning Performance
SQL Specification
Introduction
Data Types
Introduction
Numeric types
Character types
Date/Time types
Boolean types
Type Conversion
ROW IDs
SQL Syntax Conventions
SQL Syntax Conventions
Data Definition Language (DDL) Commands
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Manipulation Language Commands
INSERT
UPDATE
DELETE
Transaction Control Language Commands
Transaction Control Language Commands
SET TRANSACTION
Data Query Language
SELECT
EXPLAIN
Hints
Overview
General notes
Join hints
Hints for parallelism of distributed operations
Other hints
SQL Functions and Operators
SQL Functions and Operators
Comparison Functions and Operators
Mathematical Functions and Operators
String Functions and Operators
Date/Time Functions and Operators
Conditional Expressions
Convert Functions
Aggregate Functions
Subquery Expressions
Managing Users
CREATE USER
ALTER USER
DROP USER
System Monitoring
Using System Monitoring Views
SHOW SYSTEM VIEWS
Database Catalog Data
Database Catalog Data
SHOW TABLES
SHOW TABLE DEVICES
SHOW INDEX
SHOW INDEX DEVICES
SHOW COLUMNS
SHOW CONSTRAINTS
SHOW USERS
System Catalog Data
Dynamic System Data
System Management
Appendices
Identifiers Limitations
Database Limitations
Reserved Words
Database Catalog Data
Database Catalog Data
The database catalog views maintain information about the database objects (tables, indexes, etc.).
Was this page helpful?
Yes
No
SHOW SYSTEM VIEWS
SHOW TABLES
Assistant
Responses are generated using AI and may contain mistakes.