SQL Syntax

ABORT
ALTER APP WORKLOAD GROUP MAPPING
ALTER AUDIT POLICY
ALTER COORDINATOR
ALTER DATABASE
ALTER DATA SOURCE
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN TABLE (for Import and Export)
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER LARGE OBJECT
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER NODE
ALTER NODE GROUP
ALTER RESOURCE LABEL
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLESPACE
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ALTER WORKLOAD GROUP
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE APP WORKLOAD GROUP MAPPING
CREATE AUDIT POLICY
CREATE BARRIER
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATA SOURCE
CREATE DIRECTORY
CREATE FOREIGN TABLE (for Import and Export)
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE NODE
CREATE NODE GROUP
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE RESOURCE POOL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TEXT SEARCH CONFIGURATION
CREATE TEXT SEARCH DICTIONARY
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE WORKLOAD GROUP
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP APP WORKLOAD GROUP MAPPING
DROP AUDIT POLICY
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATA SOURCE
DROP DIRECTORY
DROP FOREIGN TABLE
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PROCEDURE
DROP RESOURCE LABEL
DROP RESOURCE POOL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TEXT SEARCH CONFIGURATION
DROP TEXT SEARCH DICTIONARY
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
DROP WORKLOAD GROUP
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXECUTE DIRECT
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
INSERT
LOCK
MOVE
MERGE INTO
PREDICT BY
PREPARE
PREPARE TRANSACTION
REASSIGN OWNED
REINDEX
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
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
START TRANSACTION
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