SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Language Elements

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

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-176,

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

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

page 2-12, and CREATE VIEW Statement on page 2-142.