SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
U-15
USAGES Table
USAGES Table
The USAGES table is a catalog table that keeps records of dependencies between
objects and between programs and objects. Table U-1 describes the contents of the
USAGES table. In the column descriptions, the terms initial object and used
object refer to an object on which another object depends. The dependent object is
called a using object.
The USAGES table was created in version 1. The CP option was added to
USEDOBJTYPE and USINGOBJTYPE in version 300.
The relations recorded in the USAGES table are:

Program uses view, table, or index

View uses view or table

Index uses table

Table, view, index, or program uses collation
If a table or index is partitioned or a view has an underlying partitioned table, the
relations are established with the primary partition and recorded in the primary
partition's catalog.
Relations between objects that reside in separate catalogs appear in both catalogs.
Relations between partitions and relations to constraints, comments, or files are not
recorded. This information is already present in other catalogs.
Table U-1. The USAGES Table
Column Name Data Type Description
1 USEDOBJNAME * CHAR(34) Name of initial object
2 USEDOBJTYPE * CHAR(2) CP if collation
IN if index
TA if table
VI if view
3 RELATIONSHIPTYPE * CHAR(2) DP if using object depends on used object
4 USINGOBJNAME * CHAR(34) Name of dependent object
5 USINGOBJTYPE * CHAR(2) IN if index
VI if view
PG if program
TA if table
6 USEDCATALOGNAME CHAR(25) Subvolume of catalog that describes initial
object
7 USINGCATALOGNAME CHAR(25) Subvolume of catalog that describes
dependent object
* Indicates primary key