SQL 命令

SQL 語言包含您用來建立和操作資料庫物件、執行查詢、載入資料表，以及修改資料表中資料的命令。

Amazon Redshift 以 PostgreSQL 為基礎。在設計和開發您的資料倉儲應用程式時，您必須知道 Amazon Redshift 與 PostgreSQL 之間有多項重要的差異。如需 Amazon Redshift SQL 與 PostgreSQL 之間差異的相關資訊，請參閱 Amazon Redshift 和 PostgreSQL。

注意

單一 SQL 陳述式的大小上限為 16 MB。

主題

• ABORT
• ALTER DATABASE
• ALTER DATASHARE
• ALTER DEFAULT PRIVILEGES
• ALTER EXTERNAL VIEW (預覽)
• ALTER FUNCTION
• ALTER GROUP
• ALTER IDENTITY PROVIDER
• ALTER MASKING POLICY
• ALTER MATERIALIZED VIEW
• ALTER RLS POLICY
• ALTER ROLE
• ALTER PROCEDURE
• ALTER SCHEMA
• ALTER SYSTEM
• ALTER TABLE
• ALTER TABLE APPEND
• ALTER USER
• ANALYZE
• ANALYZE COMPRESSION
• ATTACH MASKING POLICY
• ATTACH RLS POLICY
• BEGIN
• CALL
• 取消
• CLOSE
• COMMENT
• COMMIT
• COPY
• CREATE DATABASE
• CREATE DATASHARE
• CREATE EXTERNAL FUNCTION
• CREATE EXTERNAL SCHEMA
• CREATE EXTERNAL TABLE
• CREATE EXTERNAL VIEW (預覽)
• CREATE FUNCTION
• CREATE GROUP
• CREATE IDENTITY PROVIDER
• CREATE LIBRARY
• CREATE MASKING POLICY
• CREATE MATERIALIZED VIEW
• CREATE MODEL
• CREATE PROCEDURE
• CREATE RLS POLICY
• CREATE ROLE
• CREATE SCHEMA
• CREATE TABLE
• CREATE TABLE AS
• CREATE USER
• CREATE VIEW
• DEALLOCATE
• DECLARE
• DELETE
• DESC DATASHARE
• DESC IDENTITY PROVIDER
• DETACH MASKING POLICY
• DETACH RLS POLICY
• DROP DATABASE
• DROP DATASHARE
• DROP EXTERNAL VIEW (預覽)
• DROP FUNCTION
• DROP GROUP
• DROP IDENTITY PROVIDER
• DROP LIBRARY
• DROP MASKING POLICY
• DROP MODEL
• DROP MATERIALIZED VIEW
• DROP PROCEDURE
• DROP RLS POLICY
• DROP ROLE
• DROP SCHEMA
• DROP TABLE
• DROP USER
• DROP VIEW
• 結束
• EXECUTE
• EXPLAIN
• FETCH
• GRANT
• INSERT
• INSERT (外部資料表)
• LOCK
• MERGE
• PREPARE
• REFRESH MATERIALIZED VIEW
• RESET
• REVOKE
• ROLLBACK
• SELECT
• SELECT INTO
• SET
• SET SESSION AUTHORIZATION
• SET SESSION CHARACTERISTICS
• SHOW
• SHOW COLUMNS
• SHOW EXTERNAL TABLE
• SHOW DATABASES
• SHOW MODEL
• SHOW DATASHARES
• SHOW PROCEDURE
• SHOW SCHEMAS
• SHOW TABLE
• SHOW TABLES
• SHOW VIEW
• START TRANSACTION
• TRUNCATE
• UNLOAD
• UPDATE
• VACUUM