15.10 - ChildrenV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Database

DBC

 

View Column

Data Type

Format

Source Table.Column

Child

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

Parent

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

The V view also references the DBC.Owners table.

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.Roles
  • DBC.RoleGrants
  • You can use this view to show all the databases under a user.

    The following SELECT statement displays databases and users that are owned by the Finance database:

    ==> SELECT Parent, Child FROM DBC.ChildrenV
           WHERE Parent = ’Finance’;

    Result:

    Parent       Child
    --------     ----------
    Finance      Personnel
    Finance      Jones
    Finance      Accounting