github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/docs/generated/sql/bnf/alter_column.bnf (about)

     1  alter_onetable_stmt ::=
     2  	'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DEFAULT' a_expr
     3  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'DEFAULT'
     4  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'DEFAULT' a_expr
     5  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'DROP' 'DEFAULT'
     6  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'NOT' 'NULL'
     7  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'DROP' 'NOT' 'NULL'
     8  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'STORED'
     9  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'DROP' 'STORED'
    10  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'NOT' 'NULL'
    11  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'NOT' 'NULL'
    12  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    13  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 
    14  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename  'USING' a_expr
    15  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename  
    16  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    17  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename 'COLLATE' collation_name 
    18  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename  'USING' a_expr
    19  	| 'ALTER' 'TABLE' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename  
    20  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    21  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 
    22  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename  'USING' a_expr
    23  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename  
    24  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name  'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    25  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name  'TYPE' typename 'COLLATE' collation_name 
    26  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name  'TYPE' typename  'USING' a_expr
    27  	| 'ALTER' 'TABLE' table_name 'ALTER'  column_name  'TYPE' typename  
    28  	| 'ALTER' 'TABLE' table_name 'ALTER' 'PRIMARY' 'KEY' 'USING' 'COLUMNS' '(' index_params ')' opt_hash_sharded opt_interleave
    29  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DEFAULT' a_expr
    30  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'DEFAULT'
    31  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'DEFAULT' a_expr
    32  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'DROP' 'DEFAULT'
    33  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'NOT' 'NULL'
    34  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'DROP' 'NOT' 'NULL'
    35  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'DROP' 'STORED'
    36  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'DROP' 'STORED'
    37  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'NOT' 'NULL'
    38  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'NOT' 'NULL'
    39  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    40  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 
    41  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename  'USING' a_expr
    42  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name 'SET' 'DATA' 'TYPE' typename  
    43  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    44  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename 'COLLATE' collation_name 
    45  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename  'USING' a_expr
    46  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'COLUMN' column_name  'TYPE' typename  
    47  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    48  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename 'COLLATE' collation_name 
    49  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename  'USING' a_expr
    50  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name 'SET' 'DATA' 'TYPE' typename  
    51  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name  'TYPE' typename 'COLLATE' collation_name 'USING' a_expr
    52  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name  'TYPE' typename 'COLLATE' collation_name 
    53  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name  'TYPE' typename  'USING' a_expr
    54  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER'  column_name  'TYPE' typename  
    55  	| 'ALTER' 'TABLE' 'IF' 'EXISTS' table_name 'ALTER' 'PRIMARY' 'KEY' 'USING' 'COLUMNS' '(' index_params ')' opt_hash_sharded opt_interleave