Table Properties

Use the Tables Properties window to modify device usage, compression, permissions, cache, and the locking scheme.

Click the Name field of the table, then click the drop-down arrow and select Properties.

Pages	Properties
General	Name – specify a different table name. Using cache – select the cache to bind to the table. Identity gap – specify how ID numbers are allocated in memory. For example, a value of 10 indicates ID numbers are allocated in memory in blocks of 10. Data compression – specify the type of data compression. Index compression – specify whether to apply index compression. LOB compression – specify the level of compression. Enable incremental transfer – allows you to transfer data incrementally, and, if required, to a different product. The incremental transfer feature must be available on the selected server. Erase residual data – specify whether to remove residual data that is left over after some database operations. The options are: (Default) Off On Explicit off – allows you to override the "`erase residual data`" setting when it is turned on for a user table.
Usage	Usage – assigns space allocation for a table on a particular segment and segments to a device. Objects cannot grow beyond the space available in the segment’s device. Show – select the units of measurement.
Permission	grant or remove table permissions and predicated privileges for users, groups, or roles. Decrypt permission is visible if encrypted columns is enabled in the server. Transfer permission is visible if incremental transfer is enabled on the table.
Lock Scheme	specify the locking scheme to set how much data is locked at one time. For more information about locking scheme, see Granularity of locks and locking schemes in Performance and Tuning: Locking.
Data	Displays the table data or table contents.
Referenced By	Displays the name, object type, and owner of objects that reference the specified table.
References	Displays the name, object type, and owner of objects of the specified reference.
Columns	Displays each column belonging to the table. Clicking the column name opens the properties window for the selected column.
Indexes	Displays each index belonging to the table. Clicking the index name opens the properties window for the selected index.
Triggers	Displays each trigger belonging to the table. Clicking the trigger name opens the properties window for the selected trigger.
Foreign Keys	Displays each foreign key belonging to the table. Clicking the foreign key name opens the foreign key window for the selected index.
Check Constraints	Displays each check constraint belonging to the table. Clicking the check constraint name opens the properties window for the selected check constraint.
Partitions	Displays each partition for the table. Clicking the partition name opens the properties window for the selected partition.