Table Properties

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

Click Properties on your table to initiate the Properties wizard.

Wizard Option	Table Properties
General	Name – you can 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. 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.
Usage	Usage – assigns space allocations for a table on a particular segment and segments to a device. Objects cannot grow beyond the space available in the segment’s device. See Placing a Table on a Segment. Show – select the units of measurement.
Permission	Permission options – grant or remove table permissions for users, groups, or roles. See Setting Permissions for a Table.
Lock Scheme	Lock Scheme – specify the locking scheme to set how much data is locked at one time. See Setting the Table Locking Scheme. 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. See Column Properties.
Indexes	Displays each index belonging to the table. Clicking the index name opens the properties window for the selected index. See Index Properties.
Triggers	Displays each trigger belonging to the table. Clicking the trigger name opens the properties window for the selected trigger. See Trigger Properties.
Foreign Keys	Displays each foreign key belonging to the table. Clicking the foreign key name opens the foreign key window for the selected index. See Foreign Key Properties.
Check Constraints	Displays each check constraint belonging to the table. Clicking the check constraint name opens the properties window for the selected check constraint. See Check Constraint Properties.
Partitions	Displays each partition for the table. Clicking the partition name opens the properties window for the selected partition. See Partition Properties.