SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Language Elements

HP NonStop SQL/MX Reference Manual—544517-008

6-12

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, EXPLAIN Statement on page 2-143,

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

and views, see CREATE TABLE Statement on page 2-77, ALTER TABLE Statement on

page 2-10, and CREATE VIEW Statement on page 2-109.