Closed nene closed 3 months ago
IF EXISTS
[ONLY] name [*]
ALTER TABLE ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]
RENAME [ COLUMN ] column_name TO new_column_name
RENAME CONSTRAINT constraint_name TO new_constraint_name
RENAME TO new_name
SET SCHEMA new_schema
SET TABLESPACE new_tablespace [ NOWAIT ]
ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
DROP [ COLUMN ] [ IF EXISTS ] column_name
[ RESTRICT | CASCADE ]
ALTER [ COLUMN ] column_name
SET DATA TYPE data_type
[ SET DATA ] TYPE
[ COLLATE collation ]
[ USING expression ]
SET DEFAULT expression
DROP DEFAULT
SET NOT NULL
DROP NOT NULL
DROP EXPRESSION [ IF EXISTS ]
DROP IDENTITY [ IF EXISTS ]
ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY ( sequence_options )
SET GENERATED { ALWAYS | BY DEFAULT }
SET sequence_option
RESTART [ [ WITH ] restart ]
SET STATISTICS integer
SET ( attribute_option = value [, ... ] )
RESET ( attribute_option [, ... ] )
SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
SET COMPRESSION compression_method
ADD table_constraint
[ NOT VALID ]
ADD table_constraint_using_index
UNIQUE USING INDEX index_name
PRIMARY KEY USING INDEX index_name
ALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
VALIDATE CONSTRAINT constraint_name
DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]
DISABLE TRIGGER [ trigger_name | ALL | USER ]
ENABLE TRIGGER [ trigger_name | ALL | USER ]
ENABLE REPLICA TRIGGER trigger_name
ENABLE ALWAYS TRIGGER trigger_name
DISABLE RULE rewrite_rule_name
ENABLE RULE rewrite_rule_name
ENABLE REPLICA RULE rewrite_rule_name
ENABLE ALWAYS RULE rewrite_rule_name
DISABLE ROW LEVEL SECURITY
ENABLE ROW LEVEL SECURITY
FORCE ROW LEVEL SECURITY
NO FORCE ROW LEVEL SECURITY
CLUSTER ON index_name
SET WITHOUT CLUSTER
SET WITHOUT OIDS
SET ACCESS METHOD new_access_method
SET TABLESPACE new_tablespace
SET { LOGGED | UNLOGGED }
SET ( storage_parameter [= value] [, ... ] )
RESET ( storage_parameter [, ... ] )
INHERIT parent_table
NO INHERIT parent_table
OF type_name
NOT OF
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
REPLICA IDENTITY { DEFAULT | USING INDEX index_name | FULL | NOTHING }
CASCADE | RESTRICT
IF EXISTS[ONLY] name [*]ALTER TABLE ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]RENAME [ COLUMN ] column_name TO new_column_nameRENAME CONSTRAINT constraint_name TO new_constraint_nameRENAME TO new_nameSET SCHEMA new_schemaSET TABLESPACE new_tablespace [ NOWAIT ]ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]DROP [ COLUMN ] [ IF EXISTS ] column_name[ RESTRICT | CASCADE ]ALTER [ COLUMN ] column_name:SET DATA TYPE data_type[ SET DATA ] TYPE[ COLLATE collation ][ USING expression ]SET DEFAULT expressionDROP DEFAULTSET NOT NULLDROP NOT NULLDROP EXPRESSION [ IF EXISTS ]DROP IDENTITY [ IF EXISTS ]ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITYADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY ( sequence_options )SET GENERATED { ALWAYS | BY DEFAULT }SET sequence_optionRESTART [ [ WITH ] restart ]SET STATISTICS integerSET ( attribute_option = value [, ... ] )RESET ( attribute_option [, ... ] )SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }SET COMPRESSION compression_methodADD table_constraint[ NOT VALID ]ADD table_constraint_using_index:UNIQUE USING INDEX index_namePRIMARY KEY USING INDEX index_nameALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]VALIDATE CONSTRAINT constraint_nameDROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]DISABLE TRIGGER [ trigger_name | ALL | USER ]ENABLE TRIGGER [ trigger_name | ALL | USER ]ENABLE REPLICA TRIGGER trigger_nameENABLE ALWAYS TRIGGER trigger_nameDISABLE RULE rewrite_rule_nameENABLE RULE rewrite_rule_nameENABLE REPLICA RULE rewrite_rule_nameENABLE ALWAYS RULE rewrite_rule_nameDISABLE ROW LEVEL SECURITYENABLE ROW LEVEL SECURITYFORCE ROW LEVEL SECURITYNO FORCE ROW LEVEL SECURITYCLUSTER ON index_nameSET WITHOUT CLUSTERSET WITHOUT OIDSSET ACCESS METHOD new_access_methodSET TABLESPACE new_tablespaceSET { LOGGED | UNLOGGED }SET ( storage_parameter [= value] [, ... ] )RESET ( storage_parameter [, ... ] )INHERIT parent_tableNO INHERIT parent_tableOF type_nameNOT OFOWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }REPLICA IDENTITY { DEFAULT | USING INDEX index_name | FULL | NOTHING }IF EXISTSCASCADE | RESTRICT