Increasing the partition size of a GLOBAL AUTOINCREMENT column ensures that the supply of numbers within the partition is rarely exhausted.
You must be connected to an UltraLite database.
Create a table with a GLOBAL AUTOINCREMENT column that has a partition size specified in parentheses.
Execute the following SQL code:
CREATE TABLE customer ( id INT DEFAULT GLOBAL AUTOINCREMENT (5000), name VARCHAR(128) NOT NULL, PRIMARY KEY (id) )
A simple reference table with two columns—an integer that holds a customer identification number, and a character string that holds the customer's name is created. The ID has a partition size of 5000.
Connect to the UltraLite database in Sybase Central.
Right-click the ID column of the customer table and click Properties.
Click the Value tab.
Enter a positive integer that is greater than 5000 in the Partition Size field.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|