SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Displaying all Columns in a Table......................................................................................139
Displaying all Columns in a View.......................................................................................139
Displaying all Columns in an Index....................................................................................140
Displaying all Columns in a Primary Key or Unique Constraint...............................................140
Displaying all Columns in a NOT NULL Constraint...............................................................141
Displaying all Columns in a Referential Integrity Constraint....................................................142
Displaying the Attributes of a Column.................................................................................143
Displaying all Tables Containing a Selected Column.............................................................143
Displaying Information About Privileges...................................................................................144
Displaying all Privileges for a Table....................................................................................144
Displaying all Privileges for a View.....................................................................................145
Displaying all Privileges for a Column.................................................................................146
Displaying Information About Sequence Generators..................................................................147
Displaying all Sequence Generators...................................................................................147
Displaying Object Integrity and Consistency.............................................................................147
Displaying Version Numbers..................................................................................................147
Displaying the NonStop SQL/MX Release Identifier..............................................................148
Displaying the Schema Version..........................................................................................148
Displaying the System Schema Version................................................................................148
Displaying the Object Schema Version (OSV)......................................................................148
Displaying the Object Feature Version (OFV).......................................................................148
7 Adding, Altering, and Dropping SQL/MX Database Objects.......................150
Planning Operations on SQL/MX Objects................................................................................150
Adding Objects to an SQL/MX Database................................................................................150
Authorization Requirements for Adding Database Objects.....................................................151
Adding Catalogs.............................................................................................................152
Adding Columns to an SQL/MX Table................................................................................152
Adding Constraints..........................................................................................................154
Adding Indexes to SQL/MX Tables.....................................................................................155
Adding Partitions to SQL/MX Tables and Indexes.................................................................157
Adding Schemas.............................................................................................................159
Adding Sequence Generators............................................................................................159
Adding SQL/MP Aliases...................................................................................................160
Adding Stored Procedures in Java (SPJs).............................................................................160
Adding SQL/MX Tables....................................................................................................160
Adding Triggers...............................................................................................................161
Adding Views..................................................................................................................161
Altering Objects in an SQL/MX Database...............................................................................162
Authorization Requirements for Altering Database Objects.....................................................163
Altering SQL/MX Indexes.................................................................................................164
Altering Partitions for SQL/MX Tables and Indexes...............................................................164
Altering SQL/MP Aliases..................................................................................................165
Altering SPJs...................................................................................................................165
Altering System Defaults....................................................................................................165
Altering SQL/MX Tables...................................................................................................166
Altering Sequence Generators...........................................................................................167
Altering Sequence Generator Privileges..............................................................................168
Altering Triggers..............................................................................................................168
Altering Views.................................................................................................................168
Dropping Objects From an SQL/MX Database.........................................................................168
Authorization Requirements for Dropping Database Objects..................................................169
Dropping Catalogs..........................................................................................................170
Dropping Columns from an SQL/MX Table.........................................................................170
Dropping Constraints........................................................................................................171
Contents 7