CODEWITHSUNDEEP
azureazure-sql-databasealter-table
Shaiju T
Shaiju T

Reputation: 6609

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;

Upvotes: 6

Views: 13078

Answers (1)

maya-msft
maya-msft

Reputation: 432

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.

Upvotes: 8

Related Questions