SQL Commands ALTER FOREIGN SERVER – Alters a foreign server definition. ALTER FOREIGN TABLE – Alters a foreign table definition. ALTER ML CONFIGURATION – Modifies an ML configuration. ALTER MODEL – Modifies a model ALTER TABLE – Modifies a table. ALTER USER – Changes a user’s password. ALTER VIEW – Modifies a view. BUILD INDEX – Populates one or more indices with data. CALL – Invokes a stored procedure. CANCEL QUERY – Cancels a query that is currently running on the system. CASE – Chooses one of a specified set of values depending on some condition. %CHECKPRIV – Checks whether the user holds a specified privilege. CLOSE – Closes a cursor. COMMIT – Commits work performed during a transaction. CREATE AGGREGATE – Creates a user-defined aggregate function. CREATE DATABASE – Creates a database (namespace). CREATE FOREIGN SERVER – Creates a foreign server. CREATE FOREIGN TABLE – Creates a foreign table. CREATE FUNCTION – Creates a function as a method in a class. CREATE INDEX – Creates an index for a table. CREATE METHOD – Creates a method in a class. CREATE ML CONFIGURATION – Creates an ML configuration. CREATE MODEL – Creates a model definition. CREATE PROCEDURE – Creates a method or query which is exposed as an SQL stored procedure. CREATE QUERY – Creates a query. CREATE ROLE – Creates a role. CREATE SCHEMA – Creates a schema. CREATE TABLE – Creates a table definition. CREATE TRIGGER – Creates a trigger. CREATE USER – Creates a user account. CREATE VIEW – Creates a view. DECLARE – Declares a cursor. DELETE – Removes rows from a table. DROP AGGREGATE – Deletes a user-defined aggregate function. DROP DATABASE – Deletes a database (namespace). DROP FOREIGN SERVER – Drops a foreign server. DROP FOREIGN TABLE – Drops a foreign table. DROP FUNCTION – Deletes a function. DROP INDEX – Removes an index. DROP METHOD – Deletes a method. DROP ML CONFIGURATION – Deletes an ML configuration. DROP MODEL – Deletes a model. DROP PROCEDURE – Deletes a procedure. DROP QUERY – Deletes a query. DROP ROLE – Deletes a role. DROP SCHEMA – Deletes the schema definition. DROP TABLE – Deletes a table and (optionally) its data. DROP TRIGGER – Deletes a trigger. DROP USER – Removes a user account. DROP VIEW – Deletes a view. EXPLAIN – Returns the query plan(s) for a specified query. FETCH – Repositions a cursor, and retrieves data from it. FREEZE PLANS – Freezes one or more query plans. GRANT – Grants privileges to a user or role. INSERT – Adds new rows to a table. INSERT OR UPDATE – Adds new rows or updates existing rows in a table. %INTRANSACTION – Shows transaction state. JOIN – A SELECT subclause that creates a table based on the data in two tables. LOAD DATA – Loads data into a table. LOCK – Locks a table. OPEN – Opens a cursor. PURGE CACHED QUERIES – Deletes one or more cached queries. REVOKE – Removes privileges from a user or role. ROLLBACK – Rolls back a transaction. SAVEPOINT – Marks a point within a transaction. SELECT – Retrieves rows from one or more tables within a database. SET ML CONFIGURATION – Sets an ML configuration as the default. SET OPTION – Sets an execution option. SET TRANSACTION – Sets parameters for transactions. START TRANSACTION – Begins a transaction. TRAIN MODEL – Trains a machine learning model. TRUNCATE TABLE – Removes all data from a table and resets counters. TUNE TABLE – Gathers table statistics based on representative data. UNFREEZE PLANS – Unfreezes one or more frozen query plans. UNLOCK – Unlocks a table. UPDATE – Sets new values for specified columns in a specified table. USE DATABASE – Sets the current namespace and database. VALIDATE MODEL – Validates a model.
