• USER GUIDE
    • Getting Started
    • Introduction to MonetDB
    • Client Interfaces
    • SQL Summary
    • SQL Manual
      • Lexical Structure
      • Data Types
      • Data Definition
        • Table Definition
        • Table Elements
        • Alter Table Definition
        • Schema Commands
        • View Definition
        • Privileges
        • Merge Tables
        • Drop Statement
        • Type Definitions
        • Comment Definition
        • Index Definitions
      • Data Manipulation
      • Importing and Exporting
      • Transaction Management
    • SQL Functions
    • SQL Programming
    • SQL Catalog
    • SQL Timing
    • Tutorials
  • ADMINISTRATOR GUIDE
  • DEVELOPER GUIDE

Need more help?

  •   GitHub Issues
  •   Stack Overflow
  •   Help Center

Documentation > USER GUIDE > SQL Manual > Data Definition

Data Definition

Schema Commands

CREATE SCHEMACOMMENT ON SCHEMAALTER SCHEMADROP SCHEMA
SET SCHEMA

Data Definition

CREATE SEQUENCECOMMENT ON SEQUENCEALTER SEQUENCEDROP SEQUENCE
CREATE TABLECOMMENT ON TABLECOMMENT ON COLUMNDROP TABLE
CREATE TABLE ASALTER TABLE ADD COLUMNALTER TABLE ALTER COLUMNALTER TABLE DROP COLUMN
CREATE TEMPORARY TABLEALTER TABLE ADD CONSTRAINTALTER TABLE DROP CONSTRAINT
ALTER TABLE RENAME TOALTER TABLE RENAME COLUMNALTER TABLE SET SCHEMA
ALTER TABLE SET INSERT ONLYALTER TABLE SET READ ONLYALTER TABLE SET READ WRITE
CREATE MERGE TABLEALTER TABLE ADD TABLEALTER TABLE SET TABLEALTER TABLE DROP TABLE
CREATE REMOTE TABLE
CREATE REPLICA TABLE
CREATE UNLOGGED TABLE
CREATE TABLE FROM LOADER
CREATE INDEXCOMMENT ON INDEXDROP INDEX
CREATE IMPRINTS INDEX
CREATE ORDERED INDEX
CREATE TRIGGERDROP TRIGGER
CREATE VIEWCOMMENT ON VIEWDROP VIEW
CREATE FUNCTIONCOMMENT ON FUNCTIONDROP FUNCTIONDROP ALL FUNCTION
CREATE FUNCTION EXTERNALCREATE FUNCTION LANGUAGE
CREATE PROCEDURECOMMENT ON PROCEDUREDROP PROCEDUREDROP ALL PROCEDURE
CREATE PROCEDURE EXTERNAL
CREATE AGGREGRATECOMMENT ON AGGREGRATEDROP AGGREGRATEDROP ALL AGGREGRATE
CREATE AGGREGRATE EXTERNAL
CREATE FILTERCOMMENT ON FILTERDROP FILTERDROP ALL FILTER
CREATE LOADERCOMMENT ON LOADERDROP LOADERDROP ALL LOADER
CREATE WINDOW EXTERNALCOMMENT ON WINDOWDROP WINDOWDROP ALL WINDOW
CREATE TYPE EXTERNADROP TYPE
DECLARE
User Defined Datatypes Table Definition

Copyright © 2008-2022 MonetDB B.V. All rights reserved