Adds one partition to the partition function. boundary_value determines the range of the new partition, and must differ from the existing boundary ranges of the partition function. Based on boundary_value, the Database Engine splits one of the existing ranges into two. Of these two, the one ...
partition_function_name Is the name of the partition function to be modified. SPLIT RANGE (boundary_value) Adds one partition to the partition function.boundary_valuedetermines the range of the new partition, and must differ from the existing boundary ranges of the partition function. Based onboun...
is used for nonpartitioned tables. However, this statement cannot be used to change the way the table itself is partitioned. To repartition a partitioned table, useALTER PARTITION SCHEMEandALTER PARTITION FUNCTION. Additionally, you cannot change the data type of a column of a partitioned ...
CreatePartitionFunctionStatement CreatePartitionSchemeStatement CreateProcedureStatement CreateQueueStatement CreateRemoteServiceBindingStatement CreateResourcePoolStatement CreateRoleStatement CreateRouteStatement CreateRuleStatement CreateSchemaStatement CreateSearchPropertyListStatement ...
CreatePartitionFunctionStatement CreatePartitionSchemeStatement CreateProcedureStatement CreateQueueStatement CreateRemoteServiceBindingStatement CreateResourcePoolStatement CreateRoleStatement CreateRouteStatement CreateRuleStatement CreateSchemaStatement CreateSearchPropertyListStatement CreateSecurityPolicyStatement Crea...
CreateOrAlterFunctionStatement CreateOrAlterProcedureStatement CreateOrAlterTriggerStatement CreateOrAlterViewStatement CreatePartitionFunctionStatement CreatePartitionSchemeStatement CreateProcedureStatement CreateQueueStatement CreateRemoteServiceBindingStatement CreateResourcePoolStatement CreateRoleStatement CreateRouteSta...
パーティション化操作におけるその他の前提条件 表の所有者でない場合、drop_table_partitionまたはtruncate_table_partition句を使用するには、DROP ANY TABLE権限が必要です。 add_table_partition、modify_table_partition、move_table_partitionおよびsplit_table_partition句を使用する場合、領域を確保する表領...
ALTER TABLE PARTITION modifies table partitioning, including adding, deleting, splitting, merging partitions, and modifying partition attributes.The name of the added par
使用partition_less_than_item语法时,分区表必须是范围分区表,否则执行会报错。 此处partition_less_than_item和创建范围分区表的时候指定分区的语法一样。 当前分区表的最后一个分区的边界为MAXVALUE,不允许添加新的分区,否则执行会报错。 列表分区的add_clause语法如下: ...
ALTERTABLEGROUP tablegroup_nameADDPARTITIONpartition_options;partition_options: {PARTITIONpartition_nameVALUESLESS THAN range_partition_expr[tg_subpartition_option][,PARTITIONpartition_nameVALUESLESS THAN range_partition_expr[tg_subpartition_option]]...}|{PARTITIONpartition_nameVALUESINlist_partition_expr[tg_...