Search code examples
azureazure-sql-databasealter-table

alter external table in sql azure

I am trying to alter external table column name to new name

I followed this post

ALTER EXTERNAL TABLE RemoteCustomerTable RENAME [OldName] column TO [Name]

Error:

Incorrect syntax near the keyword 'TABLE'.

Can external table be altered ?

Any help would be great.

Update:

As i dont see any official docs to alter external table, so i droped the external table and re-created it using this post

DROP EXTERNAL TABLE RemoteCustomerTable;
Solution

  • Alter external table is not a supported operation in Azure SQL Database. As you pointed out, DROP and then CREATE is the way to go.