Creating Models › Creating a Physical Model › Stored Procedures › Procedure Browser › Detach a Table or View from a Stored Procedure

Detach a Table or View from a Stored Procedure

You can detach a table or a view from a stored procedure using the Procedure Browser.

To detach a table or view from a stored procedure

1. Click Stored Procedures on the Model menu.

   The Stored Procedure Editor opens.

2. Click the Procedure Browser button .

   The Procedure Browser opens.

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

   Note: To detach all tables and views in the Attached Object list, click the double left arrow button.

   The tables and views that you selected to detach from the stored procedure display in the Unattached 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