SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents

HP NonStop SQL/MX Installation and Management Guide—523723-004

7. Creating an SQL/MX Database (continued)

Creating, Adding, and Dropping Constraints 7-35

Naming Constraints 7-36

Constraints Implemented With Indexes 7-36

Guidelines for Creating Constraints 7-37

Examples for Creating Constraints for SQL/MX Tables 7-37

Creating Views of SQL/MX Tables 7-37

Rules for Creating and Accessing Views 7-38

Examples for Creating Views for SQL/MX Tables 7-38

Creating Triggers 7-39

Guidelines on Using Triggers 7-39

Trigger Temporary Tables 7-39

Creating Stored Procedures in Java 7-39

Database Design Guidelines for Improving OLTP Performance 7-39

8. Querying SQL/MX Metadata

Commands for Displaying Information 8-2

DISPLAY USE OF Command 8-2

mxtool INFO Command 8-3

SHOWLABEL Command 8-3

mxtool VERIFY command 8-3

SHOWDDL Command 8-4

SQL/MX Metadata Tables 8-5

Understanding ANSI External and Internal Names 8-14

Regular Identifiers and Object Naming 8-14

Delimited Identifiers and Object Naming 8-14

Displaying System Schema Information 8-15

Locating System Schema Tables 8-15

Locating System Defaults Schema Tables 8-18

Locating MXCS Schema Tables 8-21

Displaying Catalog Information 8-22

Displaying a Catalog UID 8-22

Displaying All Catalogs Visible on a Node 8-23

Determining Whether a Catalog is Local or Remote 8-23

Displaying All Schemas in a Catalog 8-24

Displaying the Guardian Location of the Metadata Tables for a Catalog 8-24

Displaying the Attributes of a Catalog 8-25

Displaying Schema Information 8-25

Displaying a Schema UID 8-26