Previous Topic: View the Tables and Views Attached to a Stored ProcedureNext Topic: Detach a Table or View from a Stored Procedure


Attach a Table or View to a Stored Procedure

You can attach a table or a view to a stored procedure using the Procedure Browser.

To attach a table or view to a stored procedure

  1. Click Stored Procedures on the Model menu.

    The Stored Procedure Editor opens.

  2. Click the Procedure Browser button Macro/Stored Procedure Browser Icon.

    The Procedure Browser opens.

  3. Select the stored procedure in the Template Name/Template Code list that you want to attach.
  4. Select a table or view in the Unattached Object list that you want to attach and click the right arrow button.

    Note: To attach all tables and views in the Unattached Object list, click the double right arrow button.

    The tables and views that you selected to attach to the stored procedure display in the Attached Object list.

  5. Click Close.

    The Procedure Browser closes.

  6. Click Close.

    The Stored Procedure Editor closes.

More information:

Attach or Detach a Teradata Table or View to a Stored Procedure