SQL Syntax

ABORT
ALTER AGGREGATE
ALTER AUDIT POLICY
ALTER DATABASE
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER EXTENSION
ALTER FOREIGN TABLE
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER PUBLICATION
ALTER PACKAGE
ALTER PROCEDURE
ALTER RESOURCE LABEL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SUBSCRIPTION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLE SUBPARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE AGGREGATE
CREATE AUDIT POLICY
CREATE CAST
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE EXTENSION
CREATE FOREIGN TABLE
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE OPERATOR
CREATE PACKAGE
CREATE PROCEDURE
CREATE PUBLICATION
CREATE RESOURCE LABEL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SUBSCRIPTION
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TABLESPACE
CREATE TABLE SUBPARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP AGGREGATE
DROP AUDIT POLICY
DROP CAST
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATA SOURCE
DROP DIRECTORY
DROP EXTENSION
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP OPERATOR
DROP OWNED
DROP PACKAGE
DROP PROCEDURE
DROP RESOURCE LABEL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP RULE
DROP PUBLICATION
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SUBSCRIPTION
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
INSERT
LOCK
MERGE INTO
MOVE
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHUTDOWN
SNAPSHOT
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES

Parent topic: SQL Reference

Previous topic: DCL Syntax Overview

Next topic: ABORT

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot