SQL Syntaxes

This section describes the SQL syntax used in Minerva. A reference to the supported SQL data types is available. Minerva also provides numerous SQL functions and operators.

ALTER SCHEMA

ALTER TABLE

ALTER VIEW

ANALYZE

CALL

COMMENT

COMMIT

CREATE SCHEMA

CREATE TABLE

CREATE TABLE AS

CREATE VIEW

DEALLOCATE PREPARE

DELETE

DESCRIBE

DESCRIBE INPUT

DESCRIBE OUTPUT

DROP SCHEMA

DROP TABLE

DROP VIEW

EXECUTE

EXECUTE IMMEDIATE

EXPLAIN

EXPLAIN ANALYZE

MATCH_RECOGNIZE

MERGE

Row pattern recognition in window structures

PREPARE

RESET SESSION

ROLLBACK

SELECT

SET PATH

SET SESSION

SET TIME ZONE

SHOW CATALOGS

SHOW COLUMNS

SHOW CREATE SCHEMA

SHOW CREATE TABLE

SHOW CREATE VIEW

SHOW FUNCTIONS

SHOW SCHEMAS

SHOW SESSION

SHOW STATS

SHOW TABLES

START TRANSACTION

TRUNCATE

UPDATE

USE

VALUES