SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Language Elements

HP NonStop SQL/MX Reference Manual—523725-004

6-11

Database Objects

A database object is an SQL entity that exists in a namespace, maps to a Guardian file

in most cases, and is registered in the system catalog. SQL/MX Release 2.x includes

SQL/MX objects. SQL/MX DML statements can access both SQL/MX and SQL/MP

objects. The subsections listed below describe these SQL/MX objects.

Collations

Constraints

Indexes

Partitions

SQL/MP Aliases

Stored Procedures

Tables

Triggers

Views

Ownership

In SQL/MX Release 2.x, the creator of a schema owns all the objects defined in the

schema. In addition, NonStop SQL/MX allows the super ID to act as the owner of any

object. In addition, you can use the GRANT and REVOKE statements to grant access

privileges for a table or view to specified users.

For more information, see Security on page 1-5, GRANT Statement on page 2-141,

and REVOKE Statement on page 2-170. For information on privileges on tables and

views, see CREATE TABLE Statement on page 2-75, ALTER TABLE Statement on

page 2-11, and CREATE VIEW Statement on page 2-105.