Reply
ToddChitt
Super User
Super User

Cannot DROP a table in a Fabric Warehouse

I have a table the had about 2 million rows of fact data. I needed to add a column but cannot simply run an ALTER TABLE statement. So I need to DROP the table and recreate it. Shouldn't be that hard.

 

But the DROP TABLE statement just hangs. 

I was able to do a DELETE FROM <my table> to remove all the rows just fine. The table is now empty. Still, the DROP TABLE statement does not complete. I let it run for 20 minutes.

I have removed it from the Default Semantic Model in the Warehouse. 

 

I don't know what else to do. I'm stuck. 

IMHO, Fabric is just not ready for prime time yet.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





1 ACCEPTED SOLUTION
v-nikhilan-msft
Community Support
Community Support

Hi @ToddChitt 
Thanks for using Fabric Community.
Can you please check if the dropping of the table is being blocked? You can use sys.dm_exec_requests to see if that is true.
sys.dm_exec_requests (Transact-SQL) - SQL Server | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

View solution in original post

3 REPLIES 3
ToddChitt
Super User
Super User

@v-nikhilan-msft Thanks, yeah, there was an INSERT statement blocking it. Not sure what from seeing as all jobs had been closed out/disconnected.

Thanks




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Hi @ToddChitt 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

v-nikhilan-msft
Community Support
Community Support

Hi @ToddChitt 
Thanks for using Fabric Community.
Can you please check if the dropping of the table is being blocked? You can use sys.dm_exec_requests to see if that is true.
sys.dm_exec_requests (Transact-SQL) - SQL Server | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)