Drop table

[#1]

goo day ,

Can you please explain me when and why to use drop table ?

for example this :

GREEN_SALES:
//Sales of product made from recycled materials
Load
CUSTOMER,
SALES_DATE,
QUANTITY
Resident 2009_SALES_DETAIL
Where Exists(RECYCLE_PRODUCT,PRODUCT_CODE);

Drop table TEMP_RECYCLE_PRODUCTS;

[alexandros17 · Accepted solution]

There are 2 tables, the TEMP_RECYCLE_PRODUCTS table is a temporary one because it is used to filter the first table only with existing products. Once the filtering is ended the TEMP_RECYCLE_PRODUCTS is deleted with a drop.