Physical Modeling › Teradata Physical Property Editors › Teradata Browser Editor for Functions, Script Templates, and Stored Procedures

Previous Topic: Define a Teradata View Column Expression

Next Topic: Attach or Detach a Teradata Table or View to a Macro

Teradata Browser Editor for Functions, Script Templates, and Stored Procedures

When you are in either the Teradata Function Editor, Teradata Script Template Editor, or the Teradata Stored Procedure Editor, you can click the browser icon Macro/Stored Procedure Browser Icon to open either the Teradata Functions Editor, Teradata Script Template Browser Editor, or the Teradata Procedures Browser.

You can use the browser to see the tables and views that are attached to a function, script template, or stored procedure and to view the code that is used by a particular template for a function, script template, or stored procedure. You can also attach tables and views in your model to existing functions, script templates, or stored procedures.

The following describes the options available for this browser:

Template Name/Template Code

Displays the name of each function template, script template, or stored procedure template in the model, along with the first line of code from either the function template, script template, or stored procedure template. This can include SQL statements and macros.

Unattached Object

Lists all tables and views in the model that are not attached to the selected function template, script template, or stored procedure template.

Attached Object

Lists the tables and views that are attached to the selected function template, script template, or stored procedure template.

Template (Read Only)

Displays the template code for the selected function template, script template, or stored procedure template.

Template Expansion (Read Only)

Displays the expanded template code for the selected function template, script template, or stored procedure template.

Attach to New Table

Lets you attach either the function template, script template, or stored procedure template to each new table that you create. Clear this check box if you want to manually attach either the function template, script template, or stored procedure template to new tables.