SQL/MP Installation and Management Guide

Contents
HP NonStop SQL/MP Installation and Management Guide—523353-004
iv
5. Creating a Database (continued)
5. Creating a Database (continued)
Defining Unique Indexes 5-47
Creating Index Partitions 5-48
Specifying Parallel Loading of Index Partitions 5-49
Creating Constraints on Data 5-51
Using the CREATE CONSTRAINT Statement 5-52
Examples of Creating Constraints 5-54
Creating Collations 5-55
Creating Collation Source Files 5-56
Creating Collation Objects 5-59
Securing Collations 5-59
6. Querying SQL/MP Catalogs
Determining Object and Program Dependencies 6-1
Using the DISPLAY USE OF Command 6-2
Displaying Information About Usages by Querying the Catalog 6-3
Displaying Current Database Definitions 6-3
Displaying Information About Catalogs 6-4
Displaying Information About Tables 6-4
Displaying Information About Views 6-5
Displaying Information About Constraints 6-6
Displaying Information About Collations 6-6
Displaying Information About Columns 6-7
Displaying Comments and Help Text 6-7
Displaying Information About Indexes 6-8
Displaying Information About Partitions 6-9
Joining Catalog Tables With UNION 6-10
Displaying File and Security Attributes 6-10
Determining Object Integrity and Consistency 6-12
Using VERIFY to Check Definitional Integrity 6-12
Using FILCHECK to Check Structural Consistency 6-14
Displaying Catalog, Object, and Program Versions 6-15
7. Adding, Altering, Removing, and Renaming Database Objects
Adding Objects to a Database 7-1
Adding Catalogs 7-2
Adding Tables 7-3
Adding Views 7-4
Adding Indexes 7-4