Table Properties window: General tab

This tab has the following components:

  • Name   Shows the name of the table. You can change the name of the table in this field.

  • Type   Shows the type of object.

  • Owner   Shows the database user who owns the table.

  • Dbspace   Shows the database file (or dbspace) where the table is located. This only applies to base tables.

  • Commit action   This option 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. If there is no commit action, it shows None (non-transactional).

  • Shared   This control only appears when the table was created as a global temporary table. Shows whether the table is shared across all connections.

  • 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.

 See also