I can’t drop the table on Azure Sql. I used to cancel a query that includes this table because it lasts at runtime. Perhaps another procedure is blocking me.
How can I solve this problem on Azure Sql?
Thank.
Try rebooting and applying:
IF EXISTS (SELECT * FROM [tablename]) DROP TABLE [tablename]