A data engineer is tasked with dropping the 'retail' database, including all its tables, under the condition that all tables within the database are managed tables. Which command should the engineer use to achieve this?