Dropping a Table V1.5

  • Open Studio
  • Right click on Unassigned tasks and select New Task.
  • Create a Workflow Stored Procedure Task and give it a Name e.g. Drop table
  • Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function DropGeometryTable.
  • Select the first parameter and enter staging (schema name) in the Edit parameter box. Then select the second parameter and enter the name of the table you wish to drop e.g.

  • Run the task. Click OK.