Hi Khaled, yes you can drop tables directly from the back-end database. I provided sample scripts for both Oracle and Postgres. You can take these scripts and modify them to include the schema and entity name. This will then generate the drop statements you will need to execute.
select 'drop table <schemaName>.' || table_name || ';' as generated_statements from all_tables where owner = '' and table_name not like 'DL_%' order by substr(table_name,3), table_name ;
select 'drop table ' || schemaname || '.' || tablename || ';' as generated_statements from pg_catalog.pg_tables where schemaname = '' and tablename not like 'dl_%' /* Do not truncate any data location system tables. */ and tablename not like 'ext_%' and tablename ilike '%%' /* ilike performs a case-insensitive comparison. */ order by substr(tablename,3), tablename ;