Databases Folder, Database Node

Database nodes represent a database in an Actian database installation. System databases are contained in a separate folder.

The title of a database node is the name of the database. Database nodes have the following subfolders as child nodes:

Contains a table node (see Tables Folder, Table Node) for each table in the database. System tables are contained in a separate subfolder.

Contains a view node (see Views Folder, View Node) for each view in the database. System views are contained in a separate subfolder.

(Ingres only) Contains a list of named database procedure nodes (see Procedures Folder, Procedure Node), routines composed of SQL statements stored in the database

(Ingres only) Contains a list of sequences (see Sequences Folder, Sequence Node), database entities used to supply a set of integer values to an application in sequential order according to defined parameters

(Ingres only) Contains a list of database events (see Events Folder, Database Event Node), occurrences that applications are designed to handle

Contains a list of synonyms (see Synonyms Folder, Synonym Node)—aliases for tables, views, or indexes

Contains functionality for managing user access to the database and viewing users that have been granted access or no access to the database (see User Node at Database Level).

For more information, see Working with Databases.

Each table node represents a table in a database. The title of a table node follows this format:

Table nodes have the following folders as child nodes:

Contains a column node (see Column Node) for each column in the table

Contains key nodes (see Key Node) for any primary or foreign keys in the table

Contains constraint nodes (see Constraint Node) for any constraints defined for the table

Contains index nodes (see Index Node) for any indexes that may be associated with the table. System indexes are contained in a separate folder.

(Ingres only) Contains nodes for any rules (see Rule Node) defined for the table. System rules are contained in a separate folder.

For more information, see Working with Tables (see Working with Tables).

Each column node represents a column in a database table or view. The title of the column node has the following format:

The default value is shown only if a default was specified for the column. For example:

Column nodes contain no child nodes.

Each node represents a key in a database table. Keys are of two different types:

The title of a key node is the list of column names included in the key definition. For example:

Key nodes contain no child nodes.

Right-clicking a key node and selecting Properties opens a dialog where you can view the details of the foreign key.

For more information, see Foreign Key Relationships.

Each constraint node represents a constraint in a database table. The title of a constraint node is generated from the type of constraint, the column names included in the constraint definition, and whether the constraint references a foreign key column. For example:

FOREIGN_KEY (fkey1,fkey2,fkey3) REFERENCES owner.other_table
PRIMARY_KEY (pkey1,pkey2)
UNIQUE("uniquecol")

Constraint nodes contain no child nodes.

Right-clicking a constraint node and selecting Properties opens a dialog where you can view the details of the constraint.

For more information, see Constraints.

Each index node represents an index in a database table or view. The title of an index node is the name of the index.

Index nodes contain no child nodes.

Right-clicking an index node and selecting Properties opens a dialog where you can view the details of the index.

For more information, see Indexes.

Each rule node represents a rule in an Ingres table. (Rules are not available for Actian Vector databases.) The title of a rule node follows this format:

Rule nodes contain no child nodes.

Right-clicking a rule node and selecting Properties opens a dialog where you can view the details of the rule.

For more information, see Using Rules.

Each view node represents a view in a database. The title of a view node follows this format:

System views are contained in a separate subfolder.

View nodes have two subfolders as child nodes for the columns and indexes of the view:

• Each column in the view has a column node in the Columns folder.

• Each index of the view has an index node (if any) in the Indexes folder. System indexes are contained in a separate subfolder.

For more information, see Working with Views.

Each column node represents a column in a database table or view. The title of the column node has the following format:

The default value is shown only if a default was specified for the column. For example:

Column nodes contain no child nodes.

Each index node represents an index in a database table or view. The title of an index node is the name of the index.

Index nodes contain no child nodes.

Right-clicking an index node and selecting Properties opens a dialog where you can view the details of the index.

For more information, see Indexes.

Each node represents a procedure within an Ingres database. (Procedures are not available for Actian Vector databases.) The title of the node follows this format:

System procedures are stored in a separate folder.

Procedure nodes contain no child nodes.

Right-clicking a procedure node and selecting Properties displays the Procedure Properties dialog (see View Procedure Properties) for the procedure, where you can view additional read-only properties of the procedure.

For more information, see Procedures.

Each sequence node represents a sequence within an Ingres database. (Sequences are not available for Actian Vector databases.) The title of the node follows this format:

Sequence nodes contain no child nodes.

Right-clicking a sequence node and selecting Properties opens a dialog where you can view the details of the sequence.

For more information, see Sequences.

Each event node represents a database event within an Ingres database. (Events are not available for Actian Vector databases.) The title of the node is the name of the database event.

Database event nodes contain no child nodes.

Right-clicking an event node and selecting Properties opens a dialog where you can view the details of the event.

For more information, see Events.

Each synonym node represents a synonym within an Actian database. The title of the node is the name of the synonym.

Synonym nodes contain no child nodes.

Right-clicking a synonym node and selecting Properties opens a dialog where you can view the details of the synonym.

For more information, see Synonyms.

This folder contains the Database Users subfolder, which lists the users who have access to this Actian database.

Each user node at the database level represents a user that explicitly has been given access or no access to the database. The title of a user node is the name of the user.