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

Contents
HP NonStop SQL/MX Installation and Management Guide—640325-001
v
7. Creating an SQL/MX Database
Creating SQL/MX Metadata 7-6
Creating Catalogs 7-7
Catalog Naming 7-7
Rules for Creating and Dropping Catalogs 7-8
Examples for Creating a Catalog 7-8
Creating Catalogs for Single-Node and Distributed Systems 7-8
Reserved Catalogs 7-8
Creating Schemas 7-9
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