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

Metadata Tables

HP NonStop SQL/MX Reference Manual—540440-003

10-8

System Schema Tables

ALL_UIDS Table

ALL_UIDS is a metadata table in NONSTOP_SQLMX_nodename.SYSTEM_SCHEMA

that lists UIDs for all objects that have metadata on the node:

An ALL_UIDS table contains one row per UID that is present in an OBJECTS table on

the local node. Object names that are regular identifiers are stored in uppercase

letters. Object names that are delimited identifiers are stored as is, without surrounding

quotation marks.

All other character columns store letters in uppercase.

Column Name Data Type Description

*1 OBJECT_UID LARGEINT UID of object

2 SCHEMA_UID LARGEINT UID of schema; link to SCHEMATA

3 OBJECT_NAME CHAR(128) Simple object name

4 OBJECT_NAME_SPACE CHAR(2) Object namespace:

CN Constraint

IX Index

LK Lock

TA Table value object (table, view,

stored procedure, SQL/MP

alias)

TR Trigger

TT Trigger temp table

* Indicates primary key