Forum Discussion
ToddChitt
Super User
Super UserCannot 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....
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.
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.