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 setSchema,//greeplum 164 disableKeys,//mysql 165 enableKeys,//mysql 166 167 modifyPrimaryKey, // teradata 168 switchPartition, // sql server, Openedge 169 maskedWith,//sql server 170 171 setPrivileges,//netezza 172 173 recluster,//snowflake 174 setOptions,//bigQuery 175 attachPartition,//postgresql 176 detachPartition,//postgresql 177 178 addColumnIfNotExists, //postgresql 179 setLogged, //postgresql 180 setUnlogged, //postgresql 181 replicaIdentity, //postgresql 182 enableRowLevelSecurity, //postgresql 183 disableRowLevelSecurity, //postgresql 184 forceRowLevelSecurity, //postgresql 185 noForceRowLevelSecurity, //postgresql 186 alterConstraint, //postgresql 187 188 swapWith,//snowflake 189 setStageFileFormat,//snowflake 190 setStageCopyOptions,//snowflake 191 setDataRetentionTimeInDays,//snowflake 192 setComment,//snowflake 193 unSetDataRetentionTimeInDays,unSetComment, 194 clusteringActionClusterBy, 195 DropIndex, 196 setSerde,//sparksql 197 setPartitionLocation,//redshift 198 algorithm, //mysql 199 lock,//mysql 200 201 setDefaultCollate,//bigquery 202 addIndex,//oracle 203 204 appendFrom,//Redshift 205 206 addSupplementalTableLogging,//oracle 207 208 refreshRelativePath,//snowflake, alter external table 209 truncatePartition,//gaussDB 210 dropSubPartition,//gaussDB 211 mergePartitions,//gaussDB 212 splitPartition,//gaussDB 213 splitSubPartition,//gaussDB 214 enableRowMovement,//gaussDB 215 disableRowMovement,//gaussDB 216 movePartition,//gaussDB 217 resetPartition,//gaussDB 218 modifyPartition,//gaussDB 219 modifyColumn,//gaussDB 220 221 mysqlTableOption,//mysql 222 convertToCharacterSet,//mysql 223 force,//mysql 224 validation,//mysql 225 encryption,//mysql 226 227 setDistributedBy,//greenplum 228 partition,//mysql 229 reorganizePartition,//mysql 230 coalescePartition,//mysql 231 removePartitioning,//mysql 232 rebuildPartition,//mysql 233 optimizePartition,//mysql 234 analyzePartition,//mysql 235 repairPartition,//mysql 236 checkPartition,//mysql 237 dropCheck,//mysql 238 alterCheck,//mysql 239 importPartition,//mysql 240 discardPartition,//mysql 241 renameIndex,//mysql 242 addPeriodForClause,//sql server 243 dropPeriodForClause,//sql server 244 245}