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

2. Do one of the following:
•
In the right pane, click SQL/MP Aliases.
•
Within the schema, click the SQL/MP Alias folder.
The following details appear:
•
Name — The name of the SQL/MP alias. Each SQL/MP alias name is a hyperlink.
Clicking the hyperlink displays the details of the SQL/MP alias.
•
Metadata UID — The internal UID number of the SQL/MP alias.
•
Creation Time: — The time and date when the SQL/MP alias was created. The Creation
Time: attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the SQL/MP alias was last redefined. The
Redefinition Time: attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing schema DDL
To view the DDL of the schema:
1.
In the navigation tree, select the schema.
2. In the right pane, click DDL.
In the right pane, a SQL statement to create the schema appears.
Viewing table properties
To view the table properties in a schema:
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.
52 Viewing database objects