Adding Object Types - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Adding Object Types

A newly created object does not appear in the Database Explorer Tree until the parent folder opens. If the parent folder is already open or has been opened during the current session, the new object does not appear until after the Refresh Database command is used, or disconnect and reconnect to the database. The same holds true when deleting an object. Table 5 shows the subfolders that are created when objects are added. For more information, see “Refreshing the Database Explorer Tree” on page 48.

 

Table 5: Sub Folders Created When Objects Are Added 

When adding a...

the following subfolder(s) are added...

Table

Columns and Indexes

Triggers (only displayed if requested on the DB Tree tab of Options)

View

Columns

Macro

Function

Procedure

Parameters