SQL/MX 2.x Reference Manual (H06.04+)

Introduction

HP NonStop SQL/MX Reference Manual—540440-003

1-18

Concurrency

Table 1-4 describes the effect of various DDL and utility operations on table

timestamps:

Table 1-4. Operations Effect on Table Timestamps

Alter Operation Timestamp Updated

ALTER INDEX No

ALTER SQL/MP ALIAS No*

ALTER TABLE Yes, if you add columns or add or drop constraints

No, if you change attributes

ALTER TRIGGER No

BACKUP No

CREATE CATALOG No

CREATE INDEX Yes, if populated

CREATE PROCEDURE No

CREATE SCHEMA No

CREATE SQLMP ALIAS No

CREATE TABLE No

CREATE TRIGGER Yes, of the table on which the trigger is defined

CREATE VIEW No

DUP No

FIXUP Yes

GRANT No

IMPORT Yes, if using fast load technique

INFO No

MODIFY, all forms Yes

mxexportddl No

MXGNAMES No

POPULATE INDEX Yes

PURGEDATA Yes

RESTORE Yes**

REVOKE No

UPDATE STATISTICS No

VERIFY No

* Manual recompilation might be required.

** If you restore an entire table (including metadata), all timestamps are updated. The table needs to be dropped

and re-created.