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

Contents
HP NonStop SQL/MX Installation and Management Guide—544536-007
v
7. Creating an SQL/MX Database (continued)
7. Creating an SQL/MX Database (continued)
SQL/MX Subvolume Naming Guidelines 7-3
SQL/MX Data File Naming Guidelines 7-3
Resource Forks 7-4
Designating Wild Cards in SQL/MX Schema Names 7-4
Using the LOCATION Clause 7-4
Using the Subvolume Option in the CREATE SCHEMA Statement 7-5
Correcting File Name Problems 7-6
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