SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
5
8. Querying SQL/MX Metadata
Schema Naming 7-9
Rules for Creating and Dropping Schemas 7-9
Examples for Creating Schemas 7-9
Access Privileges for SQL/MX Database Objects 7-10
Granting and Revoking Access Privileges to SQL/MX Database Objects 7-10
Examples for Granting Privileges 7-11
Revoking Access Privileges 7-11
Access Privileges for SQL/MX Utilities 7-11
Creating SQL/MX Tables 7-11
Security Rules for Creating and Altering SQL/MX Tables 7-12
Creating and Using Keys 7-12
Creating and Managing Partitions for SQL/MX Tables 7-16
Additional Guidelines for Creating Tables 7-21
Managing Table Data 7-23
Creating Indexes for SQL/MX Tables 7-33
Rules for Creating and Accessing Indexes 7-33
Creating an Index 7-34
Creating and Managing Partitions for SQL/MX Indexes 7-35
Creating Constraints on SQL/MX Tables 7-37
Rules for Adding and Dropping Constraints 7-37
Creating, Adding, and Dropping Constraints 7-37
Naming Constraints 7-38
Constraints Implemented With Indexes 7-38
Guidelines for Creating Constraints 7-39
Examples for Creating Constraints for SQL/MX Tables 7-39
Creating Views of SQL/MX Tables 7-39
Rules for Creating and Accessing Views 7-40
Examples for Creating Views for SQL/MX Tables
7-40
Creating Triggers
7-41
Guidelines on Using Triggers 7-41
Trigger Temporary Tables 7-41
Creating Stored Procedures in Java 7-41
Database Design Guidelines for Improving OLTP Performance 7-41
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