Azure SQL drop all tables
If you want to drop all tables, then you can use following query: You face an issue with ‘sp_msforeachtable’. So, you can create a procedure using following SQL command and try running the command above. The above script have some old syntax. But it was working at the time of writing this blog. May be,