How to drop a table in Redshift database

Below is the syntax to drop a table in Redshift database where tablename is the name of the table that needs to be dropped.

drop table tablename;

You can also drop multiple tables simultaneously as shown below:

drop table table1, table2, table3;
See also  How to print only file names from an S3 bucket