Drop external table in Azure Managed Instance
1
vote
1
answer
254
views
We moved a database from on-prem to Azure Managed Instance. But now we can't use External Tables, so we're taking a different approach. Is there a way to drop the external tables so I can use the object names for local tables?
If I run the normal instruction
DROP EXTERNAL TABLE [dbo].[MyExternalTable]
It shows the error
>Msg 102, Level 15, State 1, Line 1
>
>Incorrect syntax near 'EXTERNAL'.
If I run the command to drop like a normal table, I get a different error mentioning that this is an external table.
DROP TABLE [dbo].[MyExternalTable]
It shows the error
>Msg 3705, Level 16, State 1, Line 1
>
>Cannot use DROP TABLE with 'dbo.MyExternalTable' because 'dbo.MyExternalTable' is a EXTERNAL TABLE. Use DROP EXTERNAL TABLE.
Is there any way around this?
Asked by Luis Cazares
(139 rep)
Apr 28, 2022, 06:07 PM
Last activity: Jun 2, 2025, 05:09 PM
Last activity: Jun 2, 2025, 05:09 PM