Below is the commands to drop a tablespace.

1. Drop a tablespace without removing the physical database files.


You can see the datafile is still present at os level.

2. Drop tablespace including the physical datafiles:


Now with including contents and datafile key word, the datafile has been removed from os level too.