SQL Statements

ALTER DATABASE — change the behavior of the database

ALTER FUNCTION — change a user defined function

ALTER PROCEDURE — change a stored procedure

ALTER SEQUENCE — change the definition of a sequence generator

ALTER TABLE — change the definition of a table

ALTER TRIGGER — change the definition of a trigger

ALTER USER — change attributes of a NuoDB account

ALTER VIEW — change the definition of a view

ANALYZE — generate table and index statistics

CALL — execute a stored procedure

COMMIT — commit the current transaction

CREATE FUNCTION — create a user defined function

CREATE INDEX — define a new index

CREATE JAVACLASS — load a Java class for use in stored procedures

CREATE PROCEDURE — define a stored procedure

CREATE ROLE — define a new database role

CREATE SCHEMA — define a new schema

CREATE SEQUENCE — define a new sequence generator

CREATE TABLE — define a new table

CREATE TRIGGER — define a new trigger

CREATE USER — define a new database role

CREATE VIEW — define a new view

DELETE — delete rows of a table

DROP FUNCTION — remove a user defined function

DROP INDEX — remove an index

DROP JAVACLASS — unload a Java class

DROP PROCEDURE — remove a stored procedure or function from storage

DROP ROLE — remove a database role

DROP SCHEMA — remove a schema

DROP SEQUENCE — remove a sequence

DROP TABLE — remove a table

DROP TRIGGER — remove a trigger

DROP USER — remove a database user

DROP VIEW — remove a view

EXECUTE — execute a stored procedure

EXPLAIN — show the execution plan of a statement

GRANT — define access privileges

HELP — obtain description of SQL commands

INSERT — create new rows in a table

KILL CONNECTION — kill a long running transaction by killing the SQL connection

KILL STATEMENT — kill a long running or hanging query

MAP PARTITION — map table partition to storage group

RELEASE SAVEPOINT — destroy a previously defined savepoint

RENAME TABLE — rename a table

REPLACE — update or replace values in a table

REVOKE — remove access privileges

ROLLBACK — abort the current transaction

SAVEPOINT — define a new savepoint within the current transaction

SELECT — retrieve rows from a table or view

SET — change a runtime parameter

SHOW — display information about select database objects and states

START TRANSACTION — start a transaction block

TRUNCATE — empty a table or set of tables

UPDATE — update rows of a table

USE — specify a schema