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 modifyColumn,//gaussDB 224 225 mysqlTableOption,//mysql 226 convertToCharacterSet,//mysql 227 force,//mysql 228 validation,//mysql 229 encryption,//mysql 230 231 setDistributedBy,//greenplum 232 partition,//mysql 233 reorganizePartition,//mysql 234 coalescePartition,//mysql 235 removePartitioning,//mysql 236 rebuildPartition,//mysql 237 optimizePartition,//mysql 238 analyzePartition,//mysql 239 repairPartition,//mysql 240 checkPartition,//mysql 241 dropCheck,//mysql 242 alterCheck,//mysql 243 importPartition,//mysql 244 discardPartition,//mysql 245 renameIndex,//mysql 246 addPeriodForClause,//sql server 247 dropPeriodForClause,//sql server 248 splitRange,//sql server 249 mergeRange,//sql server 250 251 dorisTableOption,//doris 252 starrocksTableOption,//starrocks 253 254 clickhouseDeleteMutation,//clickhouse ALTER TABLE ... DELETE WHERE 255 clickhouseUpdateMutation,//clickhouse ALTER TABLE ... UPDATE ... WHERE 256 clickhouseDropPartition,//clickhouse ALTER TABLE ... DROP PARTITION (integer/string/tuple) 257 clickhouseDetachPartition,//clickhouse ALTER TABLE ... DETACH PARTITION 258 clickhouseAttachPartition,//clickhouse ALTER TABLE ... ATTACH PARTITION 259 clickhouseFreezePartition,//clickhouse ALTER TABLE ... FREEZE PARTITION 260 clickhouseUnfreezePartition,//clickhouse ALTER TABLE ... UNFREEZE PARTITION 261 clickhouseFetchPartition,//clickhouse ALTER TABLE ... FETCH PARTITION ... FROM 262 clickhouseMovePartition,//clickhouse ALTER TABLE ... MOVE PARTITION ... TO TABLE 263 clickhouseReplacePartition,//clickhouse ALTER TABLE ... REPLACE PARTITION ... FROM 264 265 oceanbaseSetTablegroup,//oceanbase ALTER TABLE ... SET TABLEGROUP = 'name' 266 oceanbaseSetOption,//oceanbase ALTER TABLE ... SET option = value (REPLICA_NUM, COMPRESSION, BLOCK_SIZE, COMMENT, etc.) 267 268}