Sample Header Ad - 728x90

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