Update database structure wizard only work to insert/delete data of table . You will not be able to drop the table itself by using update database structure wizard.
To drop the table please use SQL Code activity under Actions tab and use
DROP TABLE <tableName>
P.S : Make sure you deleting your own table and never use this to delete any OOB tables.