E-book: A Practical Guide to AI and Vector Search in Relational Databases
Read Now
LogoLogo
Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good evening

I'm here to help you with the docs.

Ctrli
AI Based on your context
  • MariaDB Server Documentation
  • Quickstart Guides
  • Server Usage
  • Server Management
  • Security
  • Architecture
  • Clients & Utilities
  • HA & Performance
  • Reference
    • SQL Structure
    • SQL Statements
      • Comment Syntax
      • Account Management
      • Administrative Statements
      • Data Definition (DDL)
        • Atomic DDL
        • CONSTRAINT
        • RENAME TABLE
        • Renaming Databases
        • ALTER
        • CREATE
          • CREATE CATALOG
          • CREATE DATABASE
          • CREATE EVENT
          • CREATE FUNCTION
          • CREATE FUNCTION UDF
          • CREATE INDEX
          • CREATE LOGFILE GROUP
          • CREATE PACKAGE
          • CREATE PACKAGE BODY
          • CREATE PROCEDURE
          • CREATE ROLE
          • CREATE SEQUENCE
          • CREATE SERVER
          • CREATE TABLE
          • CREATE TABLE with Vectors
          • CREATE TABLESPACE
          • CREATE TRIGGER
          • CREATE USER
          • CREATE VIEW
          • Generated Columns
          • Invisible Columns
          • Silent Column Changes
        • DROP
      • Data Manipulation (DML)
      • Geometry Statements
      • Prepared Statements
      • Programmatic & Compound Statements
      • Stored Routine Statements
      • Table Statements
      • Transactions
    • SQL Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
Powered by GitBook
On this page
  1. Reference
  2. SQL Statements
  3. Data Definition (DDL)

CREATE

Explore the CREATE statements used to define new database objects. This guide covers syntax for creating databases, tables, indexes, views, and stored routines.

CREATE CATALOGCREATE DATABASECREATE EVENTCREATE FUNCTIONCREATE FUNCTION UDFCREATE INDEXCREATE LOGFILE GROUPCREATE PACKAGECREATE PACKAGE BODYCREATE PROCEDURECREATE ROLECREATE SEQUENCECREATE SERVERCREATE TABLECREATE TABLE with VectorsCREATE TABLESPACECREATE TRIGGERCREATE USERCREATE VIEW
PreviousALTER TABLESPACENextCREATE DATABASE

Last updated 1 month ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2025 MariaDB. All rights reserved.

Was this helpful?