HP Integrity NonStop J-Series - Manual (Page 58)

2. In the right pane, click DDL.
The DDL tab displays the SHOW DDL output for the table. You can use this statement in MXCI
to create the table. For more information on the
SHOW DDL command, see the HP NonStop
SQL/MX Release 3.2 Reference Manual.
Viewing information related to table statistics
To view information related to table statistics:
1.
In the navigation tree, select the table.
2. In the right pane, click Statistics.
The histogram statistics for the table appear. For more information on viewing table statistics,
see
“Viewing table statistics and their properties” (page 72) .
Viewing information related to table privileges
To view information related to the table privileges:
1.
In the navigation tree, select the table.
2. In the right pane, click Privileges.
The following details related to the table privileges appear:
•
Grantee: — The name of the user whose privilege is described.
•
Grantor: — The name of the user who granted the privileges or the special SQL user
names
PUBLIC and SYSTEM .
•
With Grant: — The property indicates whether the user has grant privileges.
•
Grant Level: — The level at which the permissions are visible. The column displays
schema, object, and column values.
◦ Schema: — Indicates that permissions have been applied to the schema.
◦ Object: — Indicates that permissions were applied directly to the object whose
permissions are being displayed.
◦ Column: — Indicates that permissions are applied to the column. When an object-level
privilege applies to all columns, the individual column privileges do not appear.
Otherwise, the individual column permissions appear.
•
Privileges: — Describes the privilege of the user. The value is a list of granted privileges
that are separated by a comma. DDL and DML privileges are grouped accordingly. For
the list of privileges, see the HP NonStop SQL/MX Release 3.2 Reference Manual.
Displaying table indexes and their properties
To view the table indexes:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. Under the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. In the navigation tree, expand the contents of the system.
The list of catalogs appears.
4. Expand the contents of a catalog.
The list of schemas appears.
5. Expand the contents of a schema.
The Tables folder appears.
58 Viewing database objects