Use the Info option on the SQL menu to display information about the columns, indexes, access privileges, reference privileges, constraints (referential, primary-key, check, unique, and defaults), triggers, status, and fragmentation strategy of a table. The Info option has the same purpose as the SQL statement INFO.
The INFO menu displays the following options.
| Option | Purpose | Instructions |
|---|---|---|
| Columns | Lists the columns in the specified table, shows the data type, and shows whether null values are allowed | Displaying Column Information |
| Indexes | Lists the name, owner, and type (unique or duplicate) of each index for a specified table. (The display also shows if the index is clustered, the access method used, and the names of the columns that are indexed.) | Displaying Index Information |
| Privileges | Lists the users who have table-level Select, Update, Insert, Delete, Index, and Alter privileges | Displaying Table-Level Privileges |
| References | Lists the users who have the table-level References privilege for the specified table and which columns they can reference | Displaying References Privileges |
| Status | Lists the table name, the table owner, the size of the row (in number of bytes), the number of rows in the table (as of the last UPDATE STATISTICS statement), the number of columns in a row, and the date the table was created | none |
| cOnstraints | Displays referential, primary-key, check, and unique constraints and 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 new table to request information on the INFO menu | none |
| Fragments | Displays fragmentation strategy for the selected table | Dropping a Table |
| Exit | Returns to the SQL menu | none |
The Table option on the main menu displays a TABLE menu, which in turn has an Info option. The Info option screens are the same for both the SQL menu and TABLE menu. For more information on the Info option, see Displaying Table Information .
To leave the INFO FOR TABLE screen without requesting table information, press the Interrupt key.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]