Optionally, the partition size can be specified in parentheses immediately following the AUTOINCREMENT keyword. The partition size may be any non-negative integer, although the partition size is generally chosen so that the supply of numbers within any one partition is rarely exhausted.

For columns of type INT or UNSIGNED INT, the default partition size is 2¹⁶ = 65536; for columns of other types the default partition size is 2³² = 4294967296. Since these defaults may be inappropriate, especially if your column is not of type INT or BIGINT, it is recommended that you specify the partition size explicitly.

The following statement creates a table with two columns: an integer that holds a customer identification number and a character string that holds the customer's name. The identification number column, ID, uses the GLOBAL AUTOINCREMENT default and has a partition size of 5000.

CREATE TABLE Customers (
   ID   INT  DEFAULT GLOBAL AUTOINCREMENT (5000),
   name VARCHAR(128) NOT NULL,
   PRIMARY KEY (ID)
);

• CREATE TABLE statement
• ALTER TABLE statement