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

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
viii
8. Querying SQL/MX Metadata (continued)
Displaying the Attributes of a Column 8-56
Displaying All Tables Containing a Selected Column 8-57
8. Querying SQL/MX Metadata (continued)
Displaying Information About Privileges 8-58
Displaying All Privileges for a Table 8-59
Displaying All Privileges for a View 8-60
Displaying All Privileges for a Column 8-61
Displaying Object Integrity and Consistency 8-62
Displaying Version Numbers 8-62
Displaying the SQL/MX Release Details 8-62
Displaying the Schema Version 8-62
Displaying the System Schema Version 8-63
Displaying the Object Schema Version (OSV) 8-63
Displaying the Object Feature Version (OFV) 8-63
9. Adding, Altering, and Dropping SQL/MX Database Objects
Planning Operations on SQL/MX Objects 9-1
Adding Objects to an SQL/MX Database 9-2
Authorization Requirements for Adding Database Objects 9-3
Adding Catalogs 9-4
Adding Columns 9-5
Adding Constraints 9-7
Adding Indexes 9-8
Adding Partitions to Tables and Indexes 9-11
Adding Schemas 9-13
Adding SQL/MP Aliases 9-14
Adding Stored Procedures in Java (SPJs) 9-15
Adding Tables 9-15
Adding Triggers 9-16
Adding Views 9-17
Altering Objects in an SQL/MX Database 9-18
Authorization Requirements for Altering Database Objects 9-19
Altering Indexes 9-20
Altering Partitions 9-21
Altering SQL/MP Aliases 9-21
Altering Stored Procedures in Java (SPJs) 9-22
Altering System Defaults 9-22
Altering Tables 9-22
Altering Triggers 9-25