SQL Manual

A MonetDB database consists of schemas, users, roles and privileges.
A new database is pre-loaded with system schemas, system users and system roles.

A schema contains:
 -  zero or more (user defined) tables with optional associated indexes and triggers
 -  zero or more (user defined) views
 -  zero or more (user defined) functions
 -  zero or more (user defined) aggregate functions
 -  zero or more (user defined) window functions
 -  zero or more (user defined) procedures
 -  zero or more (user defined) sequences
 -  zero or more (user defined) types
A new database is pre-loaded with system tables, system views, system functions, system procedures and system types.

SQL commands:

• ALTER SCHEMA
• ALTER SEQUENCE
• ALTER TABLE
• ALTER USER
• ANALYZE
• BEGIN TRANSACTION
• CALL
• COMMENT ON ...
• COMMIT
• COPY BINARY INTO table FROM files
• COPY INTO table FROM file(s)
• COPY LOADER INTO table FROM function
• COPY query_result INTO file
• COPY query_result INTO BINARY files
• CREATE AGGREGATE FUNCTION
• CREATE FILTER FUNCTION
• CREATE FUNCTION
• CREATE IMPRINTS INDEX
• CREATE INDEX
• CREATE LOADER FUNCTION
• CREATE MERGE TABLE
• CREATE ORDERED INDEX
• CREATE PROCEDURE
• CREATE REMOTE TABLE
• CREATE REPLICA TABLE
• CREATE ROLE
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE TABLE
• CREATE TEMPORARY TABLE
• CREATE TEMPORARY VIEW
• CREATE TRIGGER
• CREATE TYPE
• CREATE UNLOGGED TABLE
• CREATE USER
• CREATE VIEW
• CREATE WINDOW FUNCTION
• DEALLOCATE
• DELETE
• DROP ALL ...
• DROP AGGREGATE FUNCTION
• DROP FILTER FUNCTION
• DROP FUNCTION
• DROP INDEX
• DROP LOADER FUNCTION
• DROP PROCEDURE
• DROP ROLE
• DROP SCHEMA
• DROP SEQUENCE
• DROP TABLE
• DROP TRIGGER
• DROP TYPE
• DROP USER
• DROP VIEW
• DROP WINDOW FUNCTION
• EXECUTE
• EXPLAIN
• GRANT
• INSERT
• MERGE
• PREPARE
• RELEASE SAVEPOINT
• REVOKE
• ROLLBACK
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SELECT
• SET ...
• SET CURRENT_ROLE
• SET CURRENT_SCHEMA
• SET CURRENT_TIMEZONE
• SET CURRENT_USER
• SET LOCAL TRANSACTION
• SET OPTIMIZER
• SET ROLE
• SET SCHEMA
• SET SESSION AUTHORIZATION
• SET SESSION_USER
• SET TIME ZONE
• SET TRANSACTION
• SET USER
• START TRANSACTION
• TRACE
• TRUNCATE
• UPDATE

Tip: See also Index page if you are looking for specific SQL keywords.