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 indexes 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 TABLE AS SELECT – Copies column definitions and column data from an existing table into a new table.
- 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.