Closed nene closed 3 months ago
OR REPLACE
TEMP | TEMPORARY
RECURSIVE
( column_name [, ...] ) ]
WITH ( view_option_name [= view_option_value] [, ... ] )
AS query
WITH [ CASCADED | LOCAL ] CHECK OPTION
IF NOT EXISTS
USING method
WITH ( storage_parameter [= value] [, ... ] )
TABLESPACE tablespace_name
WITH [ NO ] DATA
IF EXISTS
ALTER [ COLUMN ] column_name SET DEFAULT expression
ALTER [ COLUMN ] column_name DROP DEFAULT
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
RENAME [ COLUMN ] column_name TO new_column_name
RENAME TO new_name
SET SCHEMA new_schema
SET ( view_option_name [= view_option_value] [, ... ] )
RESET ( view_option_name [, ... ] )
[ NO ] DEPENDS ON EXTENSION extension_name
SET TABLESPACE new_tablespace [ NOWAIT ]
ALTER [ COLUMN ] column_name ...
SET STATISTICS integer
SET ( attribute_option = value [, ... ] )
RESET ( attribute_option [, ... ] )
SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
SET COMPRESSION compression_method
CLUSTER ON index_name
SET WITHOUT CLUSTER
SET ACCESS METHOD new_access_method
SET TABLESPACE new_tablespace
SET ( storage_parameter [= value] [, ... ] )
RESET ( storage_parameter [, ... ] )
CASCADE | RESTRICT
CONCURRENTLY
name
OR REPLACE
TEMP | TEMPORARY
RECURSIVE
( column_name [, ...] ) ]
WITH ( view_option_name [= view_option_value] [, ... ] )
AS query
WITH [ CASCADED | LOCAL ] CHECK OPTION
IF NOT EXISTS
USING method
WITH ( storage_parameter [= value] [, ... ] )
TABLESPACE tablespace_name
WITH [ NO ] DATA
IF EXISTS
ALTER [ COLUMN ] column_name SET DEFAULT expression
ALTER [ COLUMN ] column_name DROP DEFAULT
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
RENAME [ COLUMN ] column_name TO new_column_name
RENAME TO new_name
SET SCHEMA new_schema
SET ( view_option_name [= view_option_value] [, ... ] )
RESET ( view_option_name [, ... ] )
[ NO ] DEPENDS ON EXTENSION extension_name
SET TABLESPACE new_tablespace [ NOWAIT ]
ALTER [ COLUMN ] column_name ...
:SET STATISTICS integer
SET ( attribute_option = value [, ... ] )
RESET ( attribute_option [, ... ] )
SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
SET COMPRESSION compression_method
CLUSTER ON index_name
SET WITHOUT CLUSTER
SET ACCESS METHOD new_access_method
SET TABLESPACE new_tablespace
SET ( storage_parameter [= value] [, ... ] )
RESET ( storage_parameter [, ... ] )
OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
IF EXISTS
CASCADE | RESTRICT
CONCURRENTLY
name
WITH [ NO ] DATA