Supported and unsupported Data Definition Language (DDL) SQL commands
The following table lists the DDL commands that are supported and not supported by Aurora PostgreSQL Limitless Database, with references to limitations or more information.
| Command | Supported? | Limitations or more information |
|---|---|---|
| ALTER AGGREGATE | No | Not applicable |
| ALTER COLLATION | Yes | None |
| ALTER CONVERSION | Yes | None |
| ALTER DATABASE | No | Not applicable |
| ALTER DEFAULT PRIVILEGES | No | Not applicable |
| ALTER DOMAIN | No | Not applicable |
| ALTER EVENT TRIGGER | No | Not applicable |
| ALTER EXTENSION | Yes | Extensions |
| ALTER FOREIGN DATA WRAPPER | No | Not applicable |
| ALTER FOREIGN TABLE | No | Not applicable |
| ALTER FUNCTION | Yes | Functions |
| ALTER GROUP | Yes | None |
| ALTER INDEX | Yes | None |
| ALTER LANGUAGE | No | Not applicable |
| ALTER LARGE OBJECT | No | Not applicable |
| ALTER MATERIALIZED VIEW | No | Not applicable |
| ALTER OPERATOR | Yes | None |
| ALTER OPERATOR CLASS | Yes | None |
| ALTER OPERATOR FAMILY | Yes | None |
| ALTER POLICY | No | Not applicable |
| ALTER PROCEDURE | Yes | None |
| ALTER PUBLICATION | No | Not applicable |
| ALTER ROLE | Yes | None |
| ALTER ROUTINE | No | Not applicable |
| ALTER RULE | No | Not applicable |
| ALTER SCHEMA | Yes | None |
| ALTER SEQUENCE | Yes | Sequences |
| ALTER SERVER | No | Not applicable |
| ALTER STATISTICS | No | Not applicable |
| ALTER SUBSCRIPTION | No | Not applicable |
| ALTER SYSTEM | No | Not applicable |
| ALTER TABLE | Yes | ALTER TABLE |
| ALTER TABLESPACE | No | Not applicable |
| ALTER TEXT SEARCH CONFIGURATION | No | Not applicable |
| ALTER TEXT SEARCH DICTIONARY | No | Not applicable |
| ALTER TEXT SEARCH PARSER | No | Not applicable |
| ALTER TEXT SEARCH TEMPLATE | No | Not applicable |
| ALTER TRIGGER | No | Not applicable |
| ALTER TYPE | Yes | None |
| ALTER USER | Yes | None |
| ALTER USER MAPPING | No | Not applicable |
| ALTER VIEW | Yes | None |
| COMMENT | No | Not applicable |
| CREATE ACCESS METHOD | No | Not applicable |
| CREATE AGGREGATE | No | Not applicable |
| CREATE CAST | Yes | None |
| CREATE COLLATION | Yes | None |
| CREATE CONVERSION | Yes | None |
| CREATE DATABASE | Yes | CREATE DATABASE |
| CREATE DOMAIN | No | Not applicable |
| CREATE EVENT TRIGGER | No | Not applicable |
| CREATE EXTENSION | Yes | Extensions |
| CREATE FOREIGN DATA WRAPPER | No | Not applicable |
| CREATE FOREIGN TABLE | No | Not applicable |
| CREATE FUNCTION | Yes | Functions |
| CREATE GROUP | Yes | None |
| CREATE INDEX | Yes | CREATE INDEX |
| CREATE LANGUAGE | No | Not applicable |
| CREATE MATERIALIZED VIEW | No | Not applicable |
| CREATE OPERATOR | Yes | None |
| CREATE OPERATOR CLASS | Yes | None |
| CREATE OPERATOR FAMILY | Yes | None |
| CREATE POLICY | Yes | None |
| CREATE PROCEDURE | Yes | None |
| CREATE PUBLICATION | No | Not applicable |
| CREATE ROLE | Yes | None |
| CREATE RULE | No | Not applicable |
| CREATE SCHEMA | Yes | CREATE SCHEMA |
| CREATE SEQUENCE | Yes | Sequences |
| CREATE SERVER | No | Not applicable |
| CREATE STATISTICS | No | Not applicable |
| CREATE SUBSCRIPTION | No | Not applicable |
| CREATE TABLE | Yes | CREATE TABLE |
| CREATE TABLE AS | Yes | CREATE TABLE AS |
| CREATE TABLESPACE | No | Not applicable |
| CREATE TEMPORARY TABLE | No | Not applicable |
| CREATE TEMPORARY TABLE AS | No | Not applicable |
| CREATE TEXT SEARCH CONFIGURATION | No | Not applicable |
| CREATE TEXT SEARCH DICTIONARY | No | Not applicable |
| CREATE TEXT SEARCH PARSER | No | Not applicable |
| CREATE TEXT SEARCH TEMPLATE | No | Not applicable |
| CREATE TRANSFORM | No | Not applicable |
| CREATE TRIGGER | No | Not applicable |
| CREATE TYPE | Yes | None |
| CREATE USER | Yes | None |
| CREATE USER MAPPING | No | Not applicable |
| CREATE VIEW | Yes | None |
| DROP ACCESS METHOD | No | Not applicable |
| DROP AGGREGATE | Yes | None |
| DROP CAST | Yes | None |
| DROP COLLATION | Yes | None |
| DROP CONVERSION | Yes | None |
| DROP DATABASE | Yes | DROP DATABASE |
| DROP DOMAIN | No | Not applicable |
| DROP EVENT TRIGGER | No | Not applicable |
| DROP EXTENSION | Yes | Extensions |
| DROP FOREIGN DATA WRAPPER | No | Not applicable |
| DROP FOREIGN TABLE | No | Not applicable |
| DROP FUNCTION | Yes | Functions |
| DROP GROUP | Yes | None |
| DROP INDEX | Yes | None |
| DROP LANGUAGE | No | Not applicable |
| DROP MATERIALIZED VIEW | No | Not applicable |
| DROP OPERATOR | Yes | None |
| DROP OPERATOR CLASS | Yes | None |
| DROP OPERATOR FAMILY | Yes | None |
| DROP OWNED | No | Not applicable |
| DROP POLICY | No | Not applicable |
| DROP PROCEDURE | Yes | None |
| DROP PUBLICATION | No | Not applicable |
| DROP ROLE | Yes | None |
| DROP ROUTINE | No | Not applicable |
| DROP RULE | No | Not applicable |
| DROP SCHEMA | Yes | None |
| DROP SEQUENCE | Yes | None |
| DROP SERVER | No | Not applicable |
| DROP STATISTICS | No | Not applicable |
| DROP SUBSCRIPTION | No | None |
| DROP TABLE | Yes | None |
| DROP TABLESPACE | No | Not applicable |
| DROP TEXT SEARCH CONFIGURATION | No | Not applicable |
| DROP TEXT SEARCH DICTIONARY | No | Not applicable |
| DROP TEXT SEARCH PARSER | No | Not applicable |
| DROP TEXT SEARCH TEMPLATE | No | Not applicable |
| DROP TRANSFORM | No | Not applicable |
| DROP TRIGGER | No | Not applicable |
| DROP TYPE | Yes | None |
| DROP USER | Yes | None |
| DROP USER MAPPING | No | Not applicable |
| DROP VIEW | Yes | None |
| GRANT | Yes | None |
| REASSIGN OWNED | No | Not applicable |
| REVOKE | Yes | None |
| SECURITY LABEL | No | Not applicable |
| SELECT INTO | Yes | SELECT INTO |
| SET | Yes | None |
| SET CONSTRAINTS | No | Not applicable |
| SET ROLE | Yes | None |
| SET SESSION AUTHORIZATION | Yes | None |
| SET TRANSACTION | Yes | None |
| TRUNCATE | Yes | None |
