Lakehouse Pipeline/Notebook Script Not Dropping Tables

Hi Julian_Lee 
Thanks for using Fabric Community.
There is a similar thread related to the above scenario:
Solved: Drop table that don't have dbo schema - Microsoft Fabric Community

You cannot delete a lakehouse table using the SQL endpoint. This is not available yet. We can drop the tables which belong to the dbo schema using notebook

However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

I hope this information helps. If you have any further queries please do let us know.

Thanks