Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Getting Started
Learn the Basics
Roadmap
Tutorials
Installation Guide
Subqueries
Stored Procedures
Stored Procedures in PL/SQL
Stored Procedures in Rhai
Stored Procedures in JavaScript
Stored Procedures in Python
Event Triggers
How to Guides
How to use SQL Functions
Date and Time Handling
Creating Dynamic Web Pages with Jinja
Using the Auto-API JSON Layer
Analyze Queries with EXPLAIN
Parameter Binding
References
SQL Commands
Data Definition Language (DDL)
ALTER SEQUENCE
ALTER TABLE
CREATE FUNCTION
CREATE INDEX
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE AS SELECT
CREATE VIEW
DROP INDEX
DROP SEQUENCE
DROP TABLE
DROP VIEW
Data Manipulation Language (DML)
COPY FROM
DELETE
INSERT
TRUNCATE
UPDATE
Data Query Language (DQL)
ANALYZE
EXPLAIN
EXPLAIN ANALYZE
SELECT
PRAGMA Commands
PRAGMA
Transaction Control Language (TCL)
Transaction Control
Utility Commands
ALTER SCHEDULE
CREATE SCHEDULE
DROP SCHEDULE
INFORMATION_SCHEMA
SHOW CREATE TABLE
SHOW FUNCTIONS
SHOW INDEXES
SHOW TABLES
Connection String Reference
Embedded API Reference
Data Types in Oxibase
Constraints
Stored Procedures
Stored Procedures in PL/SQL
Stored Procedures in Rhai
Stored Procedures in JavaScript
Stored Procedures in Python
Triggers
Functions
Scalar Functions
Aggregate Functions
Table-Valued Functions
Window Functions
User-Defined Functions
Schema Management in Oxibase
SQL Features
Temporal Queries (AS OF)
JOIN Operations
Subqueries
Common Table Expressions (CTEs)
ROLLUP, CUBE, and GROUPING SETS
Operators and Expressions
CAST Operations
DISTINCT Operations
ON DUPLICATE KEY UPDATE
Savepoints
Explanations
Architecture
Architecture Overview
Storage Engine
Indexing
MVCC Implementation
Transaction Isolation
Expression Pushdown
Internal Observability System
Persistence
Unique Indexes
Performance
Performance Optimization
Query Optimizer
Semantic Query Cache
Query Execution and Optimization in Oxibase
Parallel Execution
Unikernel
NULL Handling
☀️
GitHub
SHOW CREATE TABLE
References
SQL Commands
Utility Commands
SHOW CREATE TABLE
SHOW CREATE TABLE
Shows the CREATE TABLE statement for a table.
SHOW
CREATE
TABLE
table_name
;