- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Proud to be a Super User! | |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ToddChitt
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-13-2025 01:00 PM | |||
09-25-2024 06:10 AM | |||
05-03-2024 03:26 AM | |||
09-19-2024 06:17 AM | |||
02-20-2025 02:01 AM |
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
1 |