001package gudusoft.gsqlparser; 002 003/* 004* Date: 11-4-14 005*/ 006public enum EAlterTableOptionType { 007 Unknown, 008 AddColumn, 009 ModifyColumn, 010 AlterColumn, 011 DropColumn, 012 SetUnUsedColumn, 013 DropUnUsedColumn, 014 DropColumnsContinue, 015 RenameColumn, 016 ChangeColumn, 017 RenameTable, 018 RenameTablePartition, 019 AddConstraint, 020 AddConstraintIndex, 021 AddConstraintPK, 022 AddConstraintUnique, 023 AddConstraintFK, 024 AddConstraintCheck, 025 ModifyConstraint, 026 RenameConstraint, 027 DropConstraint, 028 DropConstraintPK, 029 DropConstraintFK, 030 DropConstraintUnique, 031 DropConstraintCheck, 032 DropConstraintPartitioningKey, 033 DropConstraintRestrict, 034 DropConstraintIndex, 035 DropConstraintKey, 036 AlterConstraintFK, 037 AlterConstraintCheck, 038 CheckConstraint, 039 NocheckConstraint, 040 OraclePhysicalAttrs, 041 toOracleLogClause, 042 OracleTableP, 043 MssqlEnableTrigger, 044 MySQLTableOptons, 045 Db2PartitioningKeyDef, 046 Db2RestrictOnDrop, 047 Db2Misc, 048 ERShadowColumns,//informix 049 ModifyExtentSize,//informix 050 LockMode,//informix 051 PutClause, //informix 052 SecurityPolicy, //informix 053 054 /** 055 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetDefault} instead. 056 * 057 * Postgresql alter column set default value 058 * default value: TAlterTableOption#getDefaultExpr() 059 */ 060 AlterColumnSetDefault, 061 062 /** 063 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#DropDefault} instead. 064 */ 065 AlterColumnDropDefault, 066 067 /** 068 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#DropNotNull} instead. 069 */ 070 AlterColumnDropNotNull, 071 072 /** 073 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetNotNull} instead. 074 */ 075 AlterColumnSetNotNull, 076 077 /** 078 * Postgresql alter column set statistics 079 * statistics value: TAlterTableOption#getStatisticsValue() 080 */ 081 /** 082 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetStatistics} instead. 083 */ 084 AlterColumnSetStatistics, 085 086 /** 087 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetOptions} instead. 088 */ 089 AlterColumnSetOptions, 090 091 /** 092 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#ResetOptions} instead. 093 */ 094 AlterColumnResetOptions, 095 096 /** 097 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetStorage} instead. 098 */ 099 AlterColumnSetStorage, 100 101 /** 102 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetDataType} instead. 103 */ 104 AlterColumnSetDataType, 105 /** 106 * @deprecated As of v1.6.4.1, use AddConstraint instead 107 */ 108 AddTableConstraint, 109 ValidateConstraint, 110 dropConstraint, 111 setWithOIDS, 112 setWithoutOIDS, 113 clusterOn, 114 setWithoutCluster, 115 enableTrigger, 116 enableAlwaysTrigger, 117 enableReplicaTrigger, 118 enableTriggerAll, 119 enableTriggerUser, 120 disableTrigger, 121 disableTriggerAll, 122 disableTriggerUser, 123 enableRule, 124 enableAlwaysRule, 125 enableReplicaRule, 126 disableRule, 127 inherit, 128 noInherit, 129 ofAnyType, 130 notOf, 131 ownerTo, 132 setTablespace, 133 setStorageParameters, 134 resetStorageParameters, 135 136 replaceColumn,//hive 137 dropPartitionSpecList,//hive 138 addPartitionSpecList,//hive 139 touch,//hive 140 archive,//hive 141 unArchive,//hive 142 setTableProperties,//hive,redshift,databricks 143 unsetTableProperties,//hive,databricks 144 setFileFormat,//hive 145 setLocation,//hive,databricks 146 enableAlterProtectModeMode,//hive 147 disableAlterProtectModeMode,//hive 148 concatenate,//hive 149 serde,//hive 150 renamePartition,//hive 151 addPartition,//databricks,sparksql,mysql 152 dropPartition,//databricks,sparksql,gaussDB 153 tableBuckets,//hive 154 skewedLocation,//hive 155 notClustered, //hive 156 notSorted,//hive 157 clusteredSorted,//hive 158 partitionColumn,//hive 159 tableSkewed,//hive 160 notSkewed,//hive 161 notStoredAsDirs,//hive 162 recoverPartitions,//hive 163 exchangePartition,//hive,oracle, gauss,greenplum 164 compact,//hive 165 updateColumn,//hive 166 setSchema,//greeplum 167 disableKeys,//mysql 168 enableKeys,//mysql 169 170 modifyPrimaryKey, // teradata 171 switchPartition, // sql server, Openedge 172 maskedWith,//sql server 173 174 setPrivileges,//netezza 175 176 recluster,//snowflake 177 setOptions,//bigQuery 178 attachPartition,//postgresql 179 detachPartition,//postgresql 180 181 addColumnIfNotExists, //postgresql 182 setLogged, //postgresql 183 setUnlogged, //postgresql 184 replicaIdentity, //postgresql 185 enableRowLevelSecurity, //postgresql 186 disableRowLevelSecurity, //postgresql 187 forceRowLevelSecurity, //postgresql 188 noForceRowLevelSecurity, //postgresql 189 alterConstraint, //postgresql 190 191 swapWith,//snowflake 192 setStageFileFormat,//snowflake 193 setStageCopyOptions,//snowflake 194 setDataRetentionTimeInDays,//snowflake 195 setComment,//snowflake 196 unSetDataRetentionTimeInDays,unSetComment, 197 clusteringActionClusterBy, 198 DropIndex, 199 setSerde,//sparksql 200 setPartitionLocation,//redshift 201 algorithm, //mysql 202 lock,//mysql 203 204 setDefaultCollate,//bigquery 205 addIndex,//oracle 206 207 appendFrom,//Redshift 208 209 addSupplementalTableLogging,//oracle 210 dropSupplementalTableLogging,//oracle 211 212 refreshRelativePath,//snowflake, alter external table 213 truncatePartition,//gaussDB 214 dropSubPartition,//gaussDB 215 mergePartitions,//gaussDB 216 splitPartition,//gaussDB 217 splitSubPartition,//gaussDB 218 enableRowMovement,//gaussDB 219 disableRowMovement,//gaussDB 220 movePartition,//gaussDB 221 resetPartition,//gaussDB 222 modifyPartition,//gaussDB 223 modifySubPartition,//oracle 224 modifyColumn,//gaussDB 225 226 mysqlTableOption,//mysql 227 convertToCharacterSet,//mysql 228 force,//mysql 229 validation,//mysql 230 encryption,//mysql 231 232 setDistributedBy,//greenplum 233 partition,//mysql 234 reorganizePartition,//mysql 235 coalescePartition,//mysql 236 removePartitioning,//mysql 237 rebuildPartition,//mysql 238 optimizePartition,//mysql 239 analyzePartition,//mysql 240 repairPartition,//mysql 241 checkPartition,//mysql 242 dropCheck,//mysql 243 alterCheck,//mysql 244 importPartition,//mysql 245 discardPartition,//mysql 246 renameIndex,//mysql 247 addPeriodForClause,//sql server 248 dropPeriodForClause,//sql server 249 splitRange,//sql server 250 mergeRange,//sql server 251 252 dorisTableOption,//doris 253 starrocksTableOption,//starrocks 254 255 clickhouseDeleteMutation,//clickhouse ALTER TABLE ... DELETE WHERE 256 clickhouseUpdateMutation,//clickhouse ALTER TABLE ... UPDATE ... WHERE 257 clickhouseDropPartition,//clickhouse ALTER TABLE ... DROP PARTITION (integer/string/tuple) 258 clickhouseDetachPartition,//clickhouse ALTER TABLE ... DETACH PARTITION 259 clickhouseAttachPartition,//clickhouse ALTER TABLE ... ATTACH PARTITION 260 clickhouseFreezePartition,//clickhouse ALTER TABLE ... FREEZE PARTITION 261 clickhouseUnfreezePartition,//clickhouse ALTER TABLE ... UNFREEZE PARTITION 262 clickhouseFetchPartition,//clickhouse ALTER TABLE ... FETCH PARTITION ... FROM 263 clickhouseMovePartition,//clickhouse ALTER TABLE ... MOVE PARTITION ... TO TABLE 264 clickhouseReplacePartition,//clickhouse ALTER TABLE ... REPLACE PARTITION ... FROM 265 clickhouseModifyQuery,//clickhouse ALTER TABLE <mv> MODIFY QUERY SELECT ... 266 clickhouseModifyRefresh,//clickhouse ALTER TABLE <mv> MODIFY REFRESH schedule [DEPENDS ON ...] [SETTINGS ...] 267 clickhouseDetachPart,//clickhouse ALTER TABLE ... DETACH PART 'name' 268 clickhouseAttachPart,//clickhouse ALTER TABLE ... ATTACH PART 'name' 269 clickhouseAttachPartitionFrom,//clickhouse ALTER TABLE ... ATTACH PARTITION ... FROM table 270 clickhouseMovePart,//clickhouse ALTER TABLE ... MOVE PART 'name' TO DISK/VOLUME/TABLE 271 clickhouseMovePartitionToStorage,//clickhouse ALTER TABLE ... MOVE PARTITION ... TO DISK/VOLUME 272 clickhouseFreezePartitionWithName,//clickhouse ALTER TABLE ... FREEZE PARTITION ... WITH NAME 'x' 273 clickhouseUnfreezePartitionWithName,//clickhouse ALTER TABLE ... UNFREEZE PARTITION ... WITH NAME 'x' 274 clickhouseMaterializeColumn,//clickhouse ALTER TABLE ... MATERIALIZE COLUMN [IN PARTITION] 275 clickhouseMaterializeIndex,//clickhouse ALTER TABLE ... MATERIALIZE INDEX [IN PARTITION] 276 clickhouseMaterializeProjection,//clickhouse ALTER TABLE ... MATERIALIZE PROJECTION [IN PARTITION] 277 clickhouseClearColumn,//clickhouse ALTER TABLE ... CLEAR COLUMN [IN PARTITION] 278 clickhouseClearIndex,//clickhouse ALTER TABLE ... CLEAR INDEX [IN PARTITION] 279 clickhouseClearProjection,//clickhouse ALTER TABLE ... CLEAR PROJECTION [IN PARTITION] 280 clickhouseApplyDeletedMask,//clickhouse ALTER TABLE ... APPLY DELETED MASK [IN PARTITION] 281 clickhouseApplyPatches,//clickhouse ALTER TABLE ... APPLY PATCHES [IN PARTITION] 282 clickhouseAddProjection,//clickhouse ALTER TABLE ... ADD PROJECTION name (SELECT ...) 283 clickhouseDropProjection,//clickhouse ALTER TABLE ... DROP PROJECTION [IF EXISTS] name 284 clickhouseAddIndexExpr,//clickhouse ALTER TABLE ... ADD INDEX name expr TYPE t [GRANULARITY n] 285 clickhouseAddConstraintCheck,//clickhouse ALTER TABLE ... ADD CONSTRAINT name CHECK expr (no parens) 286 clickhouseModifySetting,//clickhouse ALTER TABLE ... MODIFY SETTING k=v[,...] 287 clickhouseResetSetting,//clickhouse ALTER TABLE ... RESET SETTING k[,...] 288 clickhouseColumnModifySetting,//clickhouse ALTER TABLE ... MODIFY COLUMN c MODIFY SETTING k=v 289 clickhouseColumnResetSetting,//clickhouse ALTER TABLE ... MODIFY COLUMN c RESET SETTING k 290 clickhouseColumnRemoveTtl,//clickhouse ALTER TABLE ... MODIFY COLUMN c REMOVE TTL 291 clickhouseRemoveTtl,//clickhouse ALTER TABLE ... REMOVE TTL 292 clickhouseModifySampleBy,//clickhouse ALTER TABLE ... MODIFY SAMPLE BY expr 293 clickhouseRemoveSampleBy,//clickhouse ALTER TABLE ... REMOVE SAMPLE BY 294 clickhouseModifyComment,//clickhouse ALTER TABLE ... MODIFY COMMENT 'text' 295 296 oceanbaseSetTablegroup,//oceanbase ALTER TABLE ... SET TABLEGROUP = 'name' 297 oceanbaseSetOption,//oceanbase ALTER TABLE ... SET option = value (REPLICA_NUM, COMPRESSION, BLOCK_SIZE, COMMENT, etc.) 298 299 exasolDistributePartitionBy,//exasol ALTER TABLE ... DISTRIBUTE BY cols / PARTITION BY cols 300 DropDistributionKeys,//exasol ALTER TABLE ... DROP DISTRIBUTION KEYS 301}