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:
Tables
Contains a table node (see Tables Folder, Table Node) for each table in the database. System tables are contained in a separate subfolder.
Views
Contains a view node (see Views Folder, View Node) for each view in the database. System views are contained in a separate subfolder.
Procedures
(Ingres only) Contains a list of named database procedure nodes (see Procedures Folder, Procedure Node), routines composed of SQL statements stored in the database
Sequences
(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
Events
(Ingres only) Contains a list of database events (see Events Folder, Database Event Node), occurrences that applications are designed to handle
Synonyms
Contains a list of synonyms (see Synonyms Folder, Synonym Node)—aliases for tables, views, or indexes
Security
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.
Tables Folder, Table Node
Each table node represents a table in a database. The title of a table node follows this format:
ownername.tablename
Table nodes have the following folders as child nodes:
Columns
Contains a column node (see Column Node) for each column in the table
Keys
Contains key nodes (see Key Node) for any primary or foreign keys in the table
Constraints
Contains constraint nodes (see Constraint Node) for any constraints defined for the table
Indexes
Contains index nodes (see Index Node) for any indexes that may be associated with the table. System indexes are contained in a separate folder.
Rules
(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).
Column Node
Each column node represents a column in a database table or view. The title of the column node has the following format:
column_name (data_type, nullability, default_value)
The default value is shown only if a default was specified for the column. For example:
table_name (char(32), not null)
Column nodes contain no child nodes.
Key Node
Each node represents a key in a database table. Keys are of two different types:
• Primary key
• Foreign key
The title of a key node is the list of column names included in the key definition. For example:
pkey1,pkey2,pkey3
fkey1,fkey2,fkey3
fkey1,fkey2,fkey3
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.
Constraint Node
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")
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.
Index Node
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.
Rule Node
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:
username."rulename"
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.
Views Folder, View Node
Each view node represents a view in a database. The title of a view node follows this format:
ownername.viewname
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.
Column Node
Each column node represents a column in a database table or view. The title of the column node has the following format:
column_name (data_type, nullability, default_value)
The default value is shown only if a default was specified for the column. For example:
table_name (char(32), not null)
Column nodes contain no child nodes.
Index Node
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.
Procedures Folder, Procedure Node
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:
username.procedurename
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.
Sequences Folder, Sequence Node
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:
username.sequencename
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.
Events Folder, Database Event Node
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.
Synonyms Folder, Synonym Node
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.
Security Folder at Database Level
This folder contains the Database Users subfolder, which lists the users who have access to this Actian database.
User Node at Database Level
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.
• User with access: 
• User with no access: 
User nodes contain no child nodes.
For more information, see Administering Users, Groups, Roles, and Profiles.
Last modified date: 06/06/2024