Comandos SQL de lenguaje de definición de datos (DDL) compatibles y no compatibles
En la siguiente tabla se enumeran los comandos de DDL compatibles y no compatibles con Base de datos ilimitada de Aurora PostgreSQL, además de referencias a las limitaciones y otra información.
| Comando | ¿Se admite? | Limitaciones o más información |
|---|---|---|
| ALTER AGGREGATE | No | No aplicable |
| ALTER COLLATION | Sí | Ninguno |
| ALTER CONVERSION | Sí | Ninguno |
| ALTER DATABASE | No | No aplicable |
| ALTER DEFAULT PRIVILEGES | No | No aplicable |
| ALTER DOMAIN | No | No aplicable |
| ALTER EVENT TRIGGER | No | No aplicable |
| ALTER EXTENSION | Sí | Extensiones |
| ALTER FOREIGN DATA WRAPPER | No | No aplicable |
| ALTER FOREIGN TABLE | No | No aplicable |
| ALTER FUNCTION | Sí | Funciones |
| ALTER GROUP | Sí | Ninguno |
| ALTER INDEX | Sí | Ninguno |
| ALTER LANGUAGE | No | No aplicable |
| ALTER LARGE OBJECT | No | No aplicable |
| ALTER MATERIALIZED VIEW | No | No aplicable |
| ALTER OPERATOR | Sí | Ninguno |
| ALTER OPERATOR CLASS | Sí | Ninguno |
| ALTER OPERATOR FAMILY | Sí | Ninguno |
| ALTER POLICY | No | No aplicable |
| ALTER PROCEDURE | Sí | Ninguno |
| ALTER PUBLICATION | No | No aplicable |
| ALTER ROLE | Sí | Ninguno |
| ALTER ROUTINE | No | No aplicable |
| ALTER RULE | No | No aplicable |
| ALTER SCHEMA | Sí | Ninguno |
| ALTER SEQUENCE | Sí | Secuencias |
| ALTER SERVER | No | No aplicable |
| ALTER STATISTICS | No | No aplicable |
| ALTER SUBSCRIPTION | No | No aplicable |
| ALTER SYSTEM | No | No aplicable |
| ALTER TABLE | Sí | ALTER TABLE |
| ALTER TABLESPACE | No | No aplicable |
| ALTER TEXT SEARCH CONFIGURATION | No | No aplicable |
| ALTER TEXT SEARCH DICTIONARY | No | No aplicable |
| ALTER TEXT SEARCH PARSER | No | No aplicable |
| ALTER TEXT SEARCH TEMPLATE | No | No aplicable |
| ALTER TRIGGER | No | No aplicable |
| ALTER TYPE | Sí | Ninguno |
| ALTER USER | Sí | Ninguno |
| ALTER USER MAPPING | No | No aplicable |
| ALTER VIEW | Sí | Ninguno |
| COMMENT | No | No aplicable |
| CREATE ACCESS METHOD | No | No aplicable |
| CREATE AGGREGATE | No | No aplicable |
| CREATE CAST | Sí | Ninguno |
| CREATE COLLATION | Sí | Ninguno |
| CREATE CONVERSION | Sí | Ninguno |
| CREATE DATABASE | Sí | CREATE DATABASE |
| CREATE DOMAIN | No | No aplicable |
| CREATE EVENT TRIGGER | No | No aplicable |
| CREATE EXTENSION | Sí | Extensiones |
| CREATE FOREIGN DATA WRAPPER | No | No aplicable |
| CREATE FOREIGN TABLE | No | No aplicable |
| CREATE FUNCTION | Sí | Funciones |
| CREATE GROUP | Sí | Ninguno |
| CREATE INDEX | Sí | CREATE INDEX |
| CREATE LANGUAGE | No | No aplicable |
| CREATE MATERIALIZED VIEW | No | No aplicable |
| CREATE OPERATOR | Sí | Ninguno |
| CREATE OPERATOR CLASS | Sí | Ninguno |
| CREATE OPERATOR FAMILY | Sí | Ninguno |
| CREATE POLICY | Sí | Ninguno |
| CREATE PROCEDURE | Sí | Ninguno |
| CREATE PUBLICATION | No | No aplicable |
| CREAR ROL | Sí | Ninguno |
| CREATE RULE | No | No aplicable |
| CREATE SCHEMA | Sí | CREATE SCHEMA |
| CREATE SEQUENCE | Sí | Secuencias |
| CREATE SERVER | No | No aplicable |
| CREATE STATISTICS | No | No aplicable |
| CREATE SUBSCRIPTION | No | No aplicable |
| CREATE TABLE | Sí | CREATE TABLE |
| CREATE TABLE AS | Sí | CREATE TABLE AS |
| CREATE TABLESPACE | No | No aplicable |
| CREATE TEMPORARY TABLE | No | No aplicable |
| CREATE TEMPORARY TABLE AS | No | No aplicable |
| CREATE TEXT SEARCH CONFIGURATION | No | No aplicable |
| CREATE TEXT SEARCH DICTIONARY | No | No aplicable |
| CREATE TEXT SEARCH PARSER | No | No aplicable |
| CREATE TEXT SEARCH TEMPLATE | No | No aplicable |
| CREATE TRANSFORM | No | No aplicable |
| CREATE TRIGGER | No | No aplicable |
| CREATE TYPE | Sí | Ninguno |
| CREAR USUARIO | Sí | Ninguno |
| CREATE USER MAPPING | No | No aplicable |
| CREATE VIEW | Sí | Ninguno |
| DROP ACCESS METHOD | No | No aplicable |
| DROP AGGREGATE | Sí | Ninguno |
| DROP CAST | Sí | Ninguno |
| DROP COLLATION | Sí | Ninguno |
| DROP CONVERSION | Sí | Ninguno |
| DROP DATABASE | Sí | DROP DATABASE |
| DROP DOMAIN | No | No aplicable |
| DROP EVENT TRIGGER | No | No aplicable |
| DROP EXTENSION | Sí | Extensiones |
| DROP FOREIGN DATA WRAPPER | No | No aplicable |
| DROP FOREIGN TABLE | No | No aplicable |
| DROP FUNCTION | Sí | Funciones |
| DROP GROUP | Sí | Ninguno |
| DROP INDEX | Sí | Ninguno |
| DROP LANGUAGE | No | No aplicable |
| DROP MATERIALIZED VIEW | No | No aplicable |
| DROP OPERATOR | Sí | Ninguno |
| DROP OPERATOR CLASS | Sí | Ninguno |
| DROP OPERATOR FAMILY | Sí | Ninguno |
| DROP OWNED | No | No aplicable |
| DROP POLICY | No | No aplicable |
| DROP PROCEDURE | Sí | Ninguno |
| DROP PUBLICATION | No | No aplicable |
| DROP ROLE | Sí | Ninguno |
| DROP ROUTINE | No | No aplicable |
| DROP RULE | No | No aplicable |
| DROP SCHEMA | Sí | Ninguno |
| DROP SEQUENCE | Sí | Ninguno |
| DROP SERVER | No | No aplicable |
| DROP STATISTICS | No | No aplicable |
| DROP SUBSCRIPTION | No | Ninguno |
| DROP TABLE | Sí | Ninguno |
| DROP TABLESPACE | No | No aplicable |
| DROP TEXT SEARCH CONFIGURATION | No | No aplicable |
| DROP TEXT SEARCH DICTIONARY | No | No aplicable |
| DROP TEXT SEARCH PARSER | No | No aplicable |
| DROP TEXT SEARCH TEMPLATE | No | No aplicable |
| DROP TRANSFORM | No | No aplicable |
| DROP TRIGGER | No | No aplicable |
| DROP TYPE | Sí | Ninguno |
| DROP USER | Sí | Ninguno |
| DROP USER MAPPING | No | No aplicable |
| DROP VIEW | Sí | Ninguno |
| GRANT | Sí | Ninguno |
| REASSIGN OWNED | No | No aplicable |
| REVOKE | Sí | Ninguno |
| SECURITY LABEL | No | No aplicable |
| SELECT INTO | Sí | SELECT INTO |
| SET | Sí | Ninguno |
| SET CONSTRAINTS | No | No aplicable |
| SET ROLE | Sí | Ninguno |
| SET SESSION AUTHORIZATION | Sí | Ninguno |
| SET TRANSACTION | Sí | Ninguno |
| TRUNCATE | Sí | Ninguno |
