Displaying Table Information

Home | Previous Page | Next Page The Table Option >

Displaying Table Information

Use the Info option on the TABLE menu to display information about columns, indexes, access privileges, reference privileges, constraints (referential, check, or unique), column default values, triggers, status, and fragmentation strategy of a table. No options exist to display table owners or information on views.

When you select the Info option on the TABLE menu, the INFO FOR TABLE screen appears, as Figure 85 shows.

Figure 85. The INFO FOR TABLE Screen

INFO FOR  TABLE >> 
Choose a table with the Arrow Keys, or enter a name, then press Return.

------------------ mydata@mydbserv ------------ Press CTRL-W for Help -------

  clients 

 customer

 orders

This screen lists the names of tables that exist in the current database. 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 appears.
If Global Language Support 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 on the customer table that dba created in the accounts database on the database server topend:

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

To leave the INFO FOR TABLE screen without requesting table information, press the Interrupt key. You return to the TABLE menu.

You can select a table in one of the following ways:

Type the table name and press RETURN.
You must use this method and include the full pathname if you want information on a table that is not in the current database.
Use the arrow keys to highlight the table name that you want and press RETURN.

For example, for the customer table, type customer or use the arrow keys to highlight it and press RETURN. The INFO menu appears, with customer in the top line, as Figure 86 and Figure 87 show.

Figure 86. The INFO Menu for Displaying Table Information (First Screen)

INFO - customer:   Columns   Indexes  Privileges  References Status  ...  
Display column names and data types for a table.

----------------- mydata@mydbserv ------------- Press CTRL-W for Help -------

Figure 87. The INFO Menu for Displaying Table Information (Second Screen)

INFO - customer:  ...   cOnstraints   triGgers  Table  Fragments  Exit  
Reference menu and primary, unique, check and defaults options.

------------------ mydata@mydbserv ------------- Press CTRL-W for Help ------

The INFO menu has the following options.

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

Tip:

From the CREATE TABLE menu, use Table-options to view extent and lock mode information, or issue a SELECT statement to list the table description in the systables system catalog table.