Database Reference
In-Depth Information
All objects created by that user are linked to his/her schema, and are eventually stored in
a
tablespace,
the default tablespace carrying the name
System
(for a full discussion of
tablespaces, see the Oracle production documentation).
To observe the structure of
User_Tables
, you may invoke the describe statement thus:
You will observe that the table contains a number of columns. Among the ones of
immediate concern are those indicated in Figure
14-2
.
Figure 14-2.
Columns of User_Tables
14.2.2 The User_Tab_Columns View
This catalog view is based on the underlying table
Tab_Columns
(DB2 equivalent being
Syscolumns
). It contains a row for every column of every table mentioned in
User_Tables
.
Figure
14-3
shows the columns of immediate concern.
Figure 14-3.
Columns of Tab_Columns
14.2.3 The User_Indexes View
This catalog view is based on the underlying table
Indexes
(DB2 equivalent being
Sysindexes
). It contains a row for every index in the user's schema. Some columns of
interest are mentioned in Figure
14-4
.