• USER GUIDE
    • Getting Started
    • Introduction to MonetDB
    • Client Interfaces
    • SQL Summary
    • SQL Manual
      • Lexical Structure
      • Data Types
      • Data Definition
        • Table Definition
        • View Definition
        • Schema Commands
        • Drop Statement
        • Privileges
        • Type Definitions
        • Merge Tables
        • Comment Definition
        • Alter Statement
        • Index Definitions
        • Table Elements
      • 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
MonetDB Foundation Launch 🎉 read more
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 TABLE FROM LOADERALTER 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 TABLECREATE REPLICA TABLECREATE TEMPORARY TABLE
CREATE INDEXCREATE IMPRINTS INDEXCREATE ORDERED INDEXDROP INDEX
COMMENT ON INDEX
CREATE TRIGGERDROP TRIGGER
CREATE 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