39.2. ÐаÑÑиÑа ÑÑабаÑÑÐ²Ð°Ð½Ð¸Ñ ÑÑиггеÑов ÑобÑÑий #
РТаблиÑе 39.1 пеÑеÑиÑÐ»ÐµÐ½Ñ ÐºÐ¾Ð¼Ð°Ð½Ð´Ñ, Ð´Ð»Ñ ÐºÐ¾ÑоÑÑÑ Ð¿Ð¾Ð´Ð´ÐµÑживаÑÑÑÑ ÑÑиггеÑÑ ÑобÑÑий.
ТаблиÑа 39.1. ÐоддеÑжка ÑÑиггеÑов ÑобÑÑий командами DDL
| Тег ÐºÐ¾Ð¼Ð°Ð½Ð´Ñ | ddl_âcommand_âstart | ddl_âcommand_âend | sql_âdrop | table_ârewrite | ÐÑимеÑÐ°Ð½Ð¸Ñ |
|---|---|---|---|---|---|
ALTER AGGREGATE | X | X | - | - | Â |
ALTER COLLATION | X | X | - | - | Â |
ALTER CONVERSION | X | X | - | - | Â |
ALTER DOMAIN | X | X | - | - | Â |
ALTER DEFAULT PRIVILEGES | X | X | - | - | Â |
ALTER EXTENSION | X | X | - | - | Â |
ALTER FOREIGN DATA WRAPPER | X | X | - | - | Â |
ALTER FOREIGN TABLE | X | X | X | - | Â |
ALTER FUNCTION | X | X | - | - | Â |
ALTER LANGUAGE | X | X | - | - | Â |
ALTER LARGE OBJECT | X | X | - | - | Â |
ALTER MATERIALIZED VIEW | X | X | - | X | Â |
ALTER OPERATOR | X | X | - | - | Â |
ALTER OPERATOR CLASS | X | X | - | - | Â |
ALTER OPERATOR FAMILY | X | X | - | - | Â |
ALTER POLICY | X | X | - | - | Â |
ALTER PROCEDURE | X | X | - | - | Â |
ALTER PUBLICATION | X | X | - | - | Â |
ALTER ROUTINE | X | X | - | - | Â |
ALTER SCHEMA | X | X | - | - | Â |
ALTER SEQUENCE | X | X | - | - | Â |
ALTER SERVER | X | X | - | - | Â |
ALTER STATISTICS | X | X | - | - | Â |
ALTER SUBSCRIPTION | X | X | - | - | Â |
ALTER TABLE | X | X | X | X | Â |
ALTER TEXT SEARCH CONFIGURATION | X | X | - | - | Â |
ALTER TEXT SEARCH DICTIONARY | X | X | - | - | Â |
ALTER TEXT SEARCH PARSER | X | X | - | - | Â |
ALTER TEXT SEARCH TEMPLATE | X | X | - | - | Â |
ALTER TRIGGER | X | X | - | - | Â |
ALTER TYPE | X | X | - | X | Â |
ALTER USER MAPPING | X | X | - | - | Â |
ALTER VIEW | X | X | - | - | Â |
COMMENT | X | X | - | - | ТолÑко Ð´Ð»Ñ Ð»Ð¾ÐºÐ°Ð»ÑнÑÑ Ð¾Ð±ÑекÑов |
CREATE ACCESS METHOD | X | X | - | - | Â |
CREATE AGGREGATE | X | X | - | - | Â |
CREATE CAST | X | X | - | - | Â |
CREATE COLLATION | X | X | - | - | Â |
CREATE CONVERSION | X | X | - | - | Â |
CREATE DOMAIN | X | X | - | - | Â |
CREATE EXTENSION | X | X | - | - | Â |
CREATE FOREIGN DATA WRAPPER | X | X | - | - | Â |
CREATE FOREIGN TABLE | X | X | - | - | Â |
CREATE FUNCTION | X | X | - | - | Â |
CREATE INDEX | X | X | - | - | Â |
CREATE LANGUAGE | X | X | - | - | Â |
CREATE MATERIALIZED VIEW | X | X | - | - | Â |
CREATE OPERATOR | X | X | - | - | Â |
CREATE OPERATOR CLASS | X | X | - | - | Â |
CREATE OPERATOR FAMILY | X | X | - | - | Â |
CREATE POLICY | X | X | - | - | Â |
CREATE PROCEDURE | X | X | - | - | Â |
CREATE PUBLICATION | X | X | - | - | Â |
CREATE RULE | X | X | - | - | Â |
CREATE SCHEMA | X | X | - | - | Â |
CREATE SEQUENCE | X | X | - | - | Â |
CREATE SERVER | X | X | - | - | Â |
CREATE STATISTICS | X | X | - | - | Â |
CREATE SUBSCRIPTION | X | X | - | - | Â |
CREATE TABLE | X | X | - | - | Â |
CREATE TABLE AS | X | X | - | - | Â |
CREATE TEXT SEARCH CONFIGURATION | X | X | - | - | Â |
CREATE TEXT SEARCH DICTIONARY | X | X | - | - | Â |
CREATE TEXT SEARCH PARSER | X | X | - | - | Â |
CREATE TEXT SEARCH TEMPLATE | X | X | - | - | Â |
CREATE TRIGGER | X | X | - | - | Â |
CREATE TYPE | X | X | - | - | Â |
CREATE USER MAPPING | X | X | - | - | Â |
CREATE VIEW | X | X | - | - | Â |
DROP ACCESS METHOD | X | X | X | - | Â |
DROP AGGREGATE | X | X | X | - | Â |
DROP CAST | X | X | X | - | Â |
DROP COLLATION | X | X | X | - | Â |
DROP CONVERSION | X | X | X | - | Â |
DROP DOMAIN | X | X | X | - | Â |
DROP EXTENSION | X | X | X | - | Â |
DROP FOREIGN DATA WRAPPER | X | X | X | - | Â |
DROP FOREIGN TABLE | X | X | X | - | Â |
DROP FUNCTION | X | X | X | - | Â |
DROP INDEX | X | X | X | - | Â |
DROP LANGUAGE | X | X | X | - | Â |
DROP MATERIALIZED VIEW | X | X | X | - | Â |
DROP OPERATOR | X | X | X | - | Â |
DROP OPERATOR CLASS | X | X | X | - | Â |
DROP OPERATOR FAMILY | X | X | X | - | Â |
DROP OWNED | X | X | X | - | Â |
DROP POLICY | X | X | X | - | Â |
DROP PROCEDURE | X | X | X | - | Â |
DROP PUBLICATION | X | X | X | - | Â |
DROP ROUTINE | X | X | X | - | Â |
DROP RULE | X | X | X | - | Â |
DROP SCHEMA | X | X | X | - | Â |
DROP SEQUENCE | X | X | X | - | Â |
DROP SERVER | X | X | X | - | Â |
DROP STATISTICS | X | X | X | - | Â |
DROP SUBSCRIPTION | X | X | X | - | Â |
DROP TABLE | X | X | X | - | Â |
DROP TEXT SEARCH CONFIGURATION | X | X | X | - | Â |
DROP TEXT SEARCH DICTIONARY | X | X | X | - | Â |
DROP TEXT SEARCH PARSER | X | X | X | - | Â |
DROP TEXT SEARCH TEMPLATE | X | X | X | - | Â |
DROP TRIGGER | X | X | X | - | Â |
DROP TYPE | X | X | X | - | Â |
DROP USER MAPPING | X | X | X | - | Â |
DROP VIEW | X | X | X | - | Â |
GRANT | X | X | - | - | ТолÑко Ð´Ð»Ñ Ð»Ð¾ÐºÐ°Ð»ÑнÑÑ Ð¾Ð±ÑекÑов |
IMPORT FOREIGN SCHEMA | X | X | - | - | Â |
REFRESH MATERIALIZED VIEW | X | X | - | - | Â |
REVOKE | X | X | - | - | ТолÑко Ð´Ð»Ñ Ð»Ð¾ÐºÐ°Ð»ÑнÑÑ Ð¾Ð±ÑекÑов |
SECURITY LABEL | X | X | - | - | ТолÑко Ð´Ð»Ñ Ð»Ð¾ÐºÐ°Ð»ÑнÑÑ Ð¾Ð±ÑекÑов |
SELECT INTO | X | X | - | - | Â |