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 OraclePhysicalAttrs, 040 toOracleLogClause, 041 OracleTableP, 042 MssqlEnableTrigger, 043 MySQLTableOptons, 044 Db2PartitioningKeyDef, 045 Db2RestrictOnDrop, 046 Db2Misc, 047 ERShadowColumns,//informix 048 ModifyExtentSize,//informix 049 LockMode,//informix 050 PutClause, //informix 051 SecurityPolicy, //informix 052 053 /** 054 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetDefault} instead. 055 * 056 * Postgresql alter column set default value 057 * default value: TAlterTableOption#getDefaultExpr() 058 */ 059 AlterColumnSetDefault, 060 061 /** 062 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#DropDefault} instead. 063 */ 064 AlterColumnDropDefault, 065 066 /** 067 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#DropNotNull} instead. 068 */ 069 AlterColumnDropNotNull, 070 071 /** 072 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetNotNull} instead. 073 */ 074 AlterColumnSetNotNull, 075 076 /** 077 * Postgresql alter column set statistics 078 * statistics value: TAlterTableOption#getStatisticsValue() 079 */ 080 /** 081 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetStatistics} instead. 082 */ 083 AlterColumnSetStatistics, 084 085 /** 086 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetOptions} instead. 087 */ 088 AlterColumnSetOptions, 089 090 /** 091 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#ResetOptions} instead. 092 */ 093 AlterColumnResetOptions, 094 095 /** 096 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetStorage} instead. 097 */ 098 AlterColumnSetStorage, 099 100 /** 101 * @deprecated As of v1.9.7.3, use {@link #AlterColumn} and {@link EAlterColumnSubType#SetDataType} instead. 102 */ 103 AlterColumnSetDataType, 104 /** 105 * @deprecated As of v1.6.4.1, use AddConstraint instead 106 */ 107 AddTableConstraint, 108 ValidateConstraint, 109 dropConstraint, 110 setWithOIDS, 111 setWithoutOIDS, 112 clusterOn, 113 setWithoutCluster, 114 enableTrigger, 115 enableAlwaysTrigger, 116 enableReplicaTrigger, 117 enableTriggerAll, 118 enableTriggerUser, 119 disableTrigger, 120 disableTriggerAll, 121 disableTriggerUser, 122 enableRule, 123 enableAlwaysRule, 124 enableReplicaRule, 125 disableRule, 126 inherit, 127 noInherit, 128 ofAnyType, 129 notOf, 130 ownerTo, 131 setTablespace, 132 setStorageParameters, 133 resetStorageParameters, 134 135 replaceColumn,//hive 136 dropPartitionSpecList,//hive 137 addPartitionSpecList,//hive 138 touch,//hive 139 archive,//hive 140 unArchive,//hive 141 setTableProperties,//hive,redshift,databricks 142 unsetTableProperties,//hive,databricks 143 setFileFormat,//hive 144 setLocation,//hive,databricks 145 enableAlterProtectModeMode,//hive 146 disableAlterProtectModeMode,//hive 147 concatenate,//hive 148 serde,//hive 149 renamePartition,//hive 150 addPartition,//databricks,sparksql,mysql 151 dropPartition,//databricks,sparksql,gaussDB 152 tableBuckets,//hive 153 skewedLocation,//hive 154 notClustered, //hive 155 notSorted,//hive 156 clusteredSorted,//hive 157 partitionColumn,//hive 158 tableSkewed,//hive 159 notSkewed,//hive 160 notStoredAsDirs,//hive 161 recoverPartitions,//hive 162 exchangePartition,//hive,oracle, gauss,greenplum 163 compact,//hive 164 updateColumn,//hive 165 setSchema,//greeplum 166 disableKeys,//mysql 167 enableKeys,//mysql 168 169 modifyPrimaryKey, // teradata 170 switchPartition, // sql server, Openedge 171 maskedWith,//sql server 172 173 setPrivileges,//netezza 174 175 recluster,//snowflake 176 setOptions,//bigQuery 177 attachPartition,//postgresql 178 detachPartition,//postgresql 179 180 addColumnIfNotExists, //postgresql 181 setLogged, //postgresql 182 setUnlogged, //postgresql 183 replicaIdentity, //postgresql 184 enableRowLevelSecurity, //postgresql 185 disableRowLevelSecurity, //postgresql 186 forceRowLevelSecurity, //postgresql 187 noForceRowLevelSecurity, //postgresql 188 alterConstraint, //postgresql 189 190 swapWith,//snowflake 191 setStageFileFormat,//snowflake 192 setStageCopyOptions,//snowflake 193 setDataRetentionTimeInDays,//snowflake 194 setComment,//snowflake 195 unSetDataRetentionTimeInDays,unSetComment, 196 clusteringActionClusterBy, 197 DropIndex, 198 setSerde,//sparksql 199 setPartitionLocation,//redshift 200 algorithm, //mysql 201 lock,//mysql 202 203 setDefaultCollate,//bigquery 204 addIndex,//oracle 205 206 appendFrom,//Redshift 207 208 addSupplementalTableLogging,//oracle 209 dropSupplementalTableLogging,//oracle 210 211 refreshRelativePath,//snowflake, alter external table 212 truncatePartition,//gaussDB 213 dropSubPartition,//gaussDB 214 mergePartitions,//gaussDB 215 splitPartition,//gaussDB 216 splitSubPartition,//gaussDB 217 enableRowMovement,//gaussDB 218 disableRowMovement,//gaussDB 219 movePartition,//gaussDB 220 resetPartition,//gaussDB 221 modifyPartition,//gaussDB 222 modifyColumn,//gaussDB 223 224 mysqlTableOption,//mysql 225 convertToCharacterSet,//mysql 226 force,//mysql 227 validation,//mysql 228 encryption,//mysql 229 230 setDistributedBy,//greenplum 231 partition,//mysql 232 reorganizePartition,//mysql 233 coalescePartition,//mysql 234 removePartitioning,//mysql 235 rebuildPartition,//mysql 236 optimizePartition,//mysql 237 analyzePartition,//mysql 238 repairPartition,//mysql 239 checkPartition,//mysql 240 dropCheck,//mysql 241 alterCheck,//mysql 242 importPartition,//mysql 243 discardPartition,//mysql 244 renameIndex,//mysql 245 addPeriodForClause,//sql server 246 dropPeriodForClause,//sql server 247 splitRange,//sql server 248 mergeRange,//sql server 249 250 dorisTableOption,//doris 251 starrocksTableOption,//starrocks 252 253 clickhouseDeleteMutation,//clickhouse ALTER TABLE ... DELETE WHERE 254 clickhouseUpdateMutation,//clickhouse ALTER TABLE ... UPDATE ... WHERE 255 clickhouseDropPartition,//clickhouse ALTER TABLE ... DROP PARTITION (integer/string/tuple) 256 clickhouseDetachPartition,//clickhouse ALTER TABLE ... DETACH PARTITION 257 clickhouseAttachPartition,//clickhouse ALTER TABLE ... ATTACH PARTITION 258 clickhouseFreezePartition,//clickhouse ALTER TABLE ... FREEZE PARTITION 259 clickhouseUnfreezePartition,//clickhouse ALTER TABLE ... UNFREEZE PARTITION 260 clickhouseFetchPartition,//clickhouse ALTER TABLE ... FETCH PARTITION ... FROM 261 clickhouseMovePartition,//clickhouse ALTER TABLE ... MOVE PARTITION ... TO TABLE 262 clickhouseReplacePartition,//clickhouse ALTER TABLE ... REPLACE PARTITION ... FROM 263 264}