There may be situations where you need to delete all the tables in a database, or clean all rows in all the tables or truncate all the tables in database. If the database contains only few tables then it is not a problem, Otherwise it would be a major task to clean the database.
Luckily Microsoft [...]

Continue reading about Delete All tables in a SQL Server Database