Deleting a Table

You can delete tables from your workspace only in the Prepare Window.

Use this functionality carefully because deleting tables may break your load plan, particularly if you have other tables built on top of the table you wish to delete. This limitation does NOT apply to new tables obtained from sorting operations because sorts do not affect the table schema.

 

Steps:

1. In the table selector of the Prepare Window, click the drop-down arrow beside table you would like to close.

2. Select Delete Table from the context menu that displays.

   The table is removed from the workspace. It is no longer available for Prep Data and Transformation operations, and you can no longer use it in join or append operations.

 

 

Related Links

• Changing a Table Path

• Working with the Table List Panel

• Refreshing Table Data

• Pinning a Table

• Transforming and Preparing Data