# this query will help to generate the drop table statement for the entire schema. So rather then dropping the tables manually one by one, use the below query:
Select 'drop table '+ table_schema+''+table_name from information schema.tables where table_name like '%enter the ailas name of the table%' and table_schema = '%Enter the schema%'
