SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Table property sheet
The General tab of the Table property sheet has the following components:
Name Shows the name of the table.
Type Shows the type of object.
Owner Shows the database user who created and owns the table.
Dbspace Shows the database file (or dbspace) where the table is located.
Name Shows the name of the primary key for the selected table. Primary keys can be named for tables in Adaptive Server Anywhere databases that are version 9 and higher.
Set Primary Key Now Opens the Set Primary Key dialog where you can specify or change the primary key for the selected table.
Columns Shows the primary key columns for the table.
Clustered Shows whether the table has a clustered index. Clustered indexes are supported for Adaptive Server Anywhere databases that are version 8.0.2 and higher.
Clustered indexes in Adaptive Server Anywhere store the table rows in approximately the same order as they appear in the corresponding index. Using a clustered index can lead to performance benefits by reducing the number of times each page needs to be read into memory. Only one index on a table can be a clustered index.
For more information about clustered indexes, see CREATE INDEX statement.
Set Clustered Index Now Opens the Set Clustered Index dialog where you can specify that an index on this table is a clustered index.
Index type Shows the type of index the table has.
Maximum hash size This information only appears for databases created with Adaptive Server Anywhere 7 or earlier. The hash size is the number of bytes used to store a value in an index.
For more information about indexes, see Indexes.
Adaptive Server Anywhere version 6 and 7 databases use regular B-tree indexes with a hash size of 10.
Comment Provides a place for you to type a text description of the table. For example, you could use this area to describe the table's purpose in the system.
On commit This control only appears when the table was created as a global temporary table. Shows whether the rows of the table are deleted or preserved when a COMMIT is executed.