Display table information

Note the following items:

• If you are not the table owner, the table name is prefixed by the owner name, as in june.clients.
• If the list of tables does not fit on one screen, the last entry is an ellipsis (...). Use the arrow keys to highlight the ellipsis, and the next page of table names are displayed.
• If globalization is enabled, the list of table names is sorted according to the database collation rules defined when the database was created. Thus, different users using different collating sequences for DB-Access see the table names in the database listed in the same order.

To request information about tables on a different database server, use the format database@server:table or database@server:owner.table at the prompt. The following example requests information about the customer table that dba created in the accounts database on the database server topend:

INFO FOR TABLE >> accounts@topend:dba.customer

The INFO menu has the following options.

Option	Purpose
Columns	Lists data type by column name and indicates which columns can contain a null value
Indexes	Describes each index that is defined for a specified table
Privileges	Lists the users who have Select, Update, Insert, Delete, Index, or Alter privileges for the specified table
References	Lists the users who have the table-level References privilege for the specified table and the names of the columns they can reference
Status	Lists the table name, owner, row size, number of rows and columns, and creation date of the current table
cOnstraints	Displays the referential, primary, unique, and check constraints, and the default values for the columns in the specified table
triGgers	Displays header and body information for a specified trigger
Table	Redisplays the INFO FOR TABLE menu so that you can select a different table for examination
Fragments	Lists fragmented dbspaces assigned to the table and, for expression-based fragmentation, displays the expression that is assigned to each dbspace
Exit	Returns to the TABLE menu