Create Table Preferences

Set create table preferences to specify defaults for creating new tables and the behavior of the table creation wizards.

Table 1. Create Table preferences: ASE
Property	Description
Max Row Per Page	Specify the maximum rows per page. Enter a value, from 0 to 256, in the corresponding text field. The default is 0.
Reserve Page Gap	Specify the reserve page gap, which is a ratio of empty pages to filled pages. For example, if you specify a reserve page gap of 8, operations fill seven pages and leave an eighth page empty. Enter a value, from 0 to 255, in the corresponding text field. The default is 0.
Identity Fap	Specify the identity gap, which is the number IDs per block assigned in memory. For example, an identity gap of 10 indicates that ID numbers are allocated in memory in blocks of 10. If the server fails or is shut down with no wait, the maximum gap between the last ID number assigned to a row and the next ID number assigned to a row is 10 numbers of memory blocks assigned for each ID. Enter a value in the corresponding text field. The default is 0.
Replacement Strategy	Specify the preferred cache replacement strategy. Valid selections are Most Recently Used and Off. Select Most Recently Used to replace pages in cache according to the most recent use. This setting is the default.
Prefetch Strategy	Set the cache prefetch strategy. Valid selections are On and Off.
Locking Scheme	Specify the locking scheme for the table. Valid values are All Pages, All Rows, and Data Pages, and the Server Wide Default.
Expected Row Size	Specify the expected size of rows for tables. Enter a value in the corresponding text field.