if in yor databse you have only tables then simply can drop user
or u can create one one store procedure to delete all table from your databse