Sql query to delete all tables and their data from a specific schema : > I need to write an SQL query to delete all tables and their data from a specific schema
> 
> For example in my database I have tables with schema name dws6 and I want a script in SQL that will delete all the tables with the schema dws6.