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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
iv
2. SQL/MX Statements
Examples of ALTER SEQUENCE 2-16
ALTER SQLMP ALIAS Statement 2-17
Syntax Description of ALTER SQLMP ALIAS 2-17
Considerations for ALTER SQLMP ALIAS 2-17
Usage Restrictions 2-17
Security of Alias 2-17
Late Bind 2-18
Examples of ALTER SQLMP ALIAS 2-18
ALTER TABLE Statement 2-19
Syntax Description of ALTER TABLE 2-21
Considerations for ALTER TABLE 2-32
Effect of Adding a Column on View Definitions 2-32
Authorization and Availability Requirements 2-32
Renaming a Table 2-32
Constraints Implemented With Indexes 2-32
Adding CHECK and FOREIGN KEY Constraints 2-33
Dropping FOREIGN KEY Constraints 2-33
Altering the MAXVALUE and INCREMENT BY options on IDENTITY
columns 2-34
Altering the MAXVALUE attribute on IDENTITY columns 2-34
IDENTITY column and redefinition timestamp 2-35
Recalibrating the Sequence Generator of an IDENTITY column 2-38
Recalibrate an IDENTITY column based on the INCREMENT BY
value 2-38
Recalibrate to a user-specified value with SELECT 2-39
Recalibrate to a user-specified value without SELECT 2-39
SQL/MX Extensions to ALTER TABLE
2-40
Considerations for Referential Integrity 2-40
Effects on TMF 2-40
Effects on RDF
2-40
Effects on open blown away
2-40
Examples of ALTER TABLE 2-42
Examples of ALTER TABLE ALTER COLUMN
2-44
Create a table with the IDENTITY column
2-44
Alter the table to allow new MAXVALUE and INCREMENT BY
values: 2-44
Example of ALTER TABLE ALTER COLUMN..RECALIBRATE 2-45
ALTER TRIGGER Statement
2-48
Syntax Description of ALTER TRIGGER
2-48
Considerations for ALTER TRIGGER 2-48