>>-INFO--+-TABLES-------------------------+--------------------><
         '-+-+-COLUMNS-+----+--FOR--table-'
           | +-INDEXES-+    |
           | '-STATUS--'    |
           +-+-PRIVILEGES-+-+
           | '-ACCESS-----' |
           '-+-FRAGMENTS--+-'
             '-REFERENCES-'
 

You can use the INFO statement with DB–Access to display information about database tables. C-style comments are not valid within the INFO statement.

Keywords of the INFO statement can display the following information.

INFO Keyword

Information Displayed

TABLES

Table names in the current database

COLUMNS

Column information for a specified table

INDEXES

Index information for a specified table

FRAGMENTS

Fragmentation strategy for a specified table

ACCESS or PRIVILEGES

Access privileges for a specified table. (The ACCESS and PRIVILEGES keywords are synonyms in this context.)

REFERENCES

References privileges for columns of a specified table

STATUS

Status information for a specified table

• TABLES Keyword

  Use TABLES to display a list of the tables in the current database, not including system catalog tables, in one of the following formats:

  • If you are the owner of the cust_calls table, it appears as cust_calls.
  • If you are not the owner of the cust_calls table, the name of the owner precedes the table name, such as 'june'.cust_calls.
• COLUMNS Keyword

  Use COLUMNS to display the names and data types of the columns in a specified table, showing for each column whether NULL values are allowed.

• INDEXES Keyword

  Use INDEXES to display the name, owner, and type of each index in a specified table, the clustered status, and listing the indexed columns.

• FRAGMENTS Keyword

  Use FRAGMENTS to display the names of dbspaces storing fragments of a table. If the table is fragmented with an expression-based distribution scheme, the INFO statement also shows the expressions.

• ACCESS or PRIVILEGES Keyword

  Use ACCESS or PRIVILEGES to display user-access privileges for a specified table. (These two keywords are synonyms in this context.)

• REFERENCES Keyword

  Use REFERENCES to display the References privilege for users for the columns of a specified table. For database-level privileges, use a SELECT statement to query the sysusers system catalog table.

• STATUS Keyword

  Use STATUS to display information about the owner, row length, number of rows and columns, creation date, and status of audit trails for a specified table.

An alternative to using the INFO statement of SQL is to use the Info command of the SQL menu or of the Table menu of DB–Access to display the same and additional information.

Related statements: GRANT and REVOKE

For a description of the Info option on the SQL menu or the TABLE menu in DB–Access, see the IBM Informix DB–Access User's Guide.