[In preview] Rename a column name in SQLDW
This request is currently in Preview for columns in user tables.
See release notes:
Scenario: We want to change the column name as it is changed in the source. And in table where we are trying to do has more than 20Billion records.
Workaround: Since rename of column is not possible currently in SQL DW we are doing CTAS of that big table.
Issues With Work around: It is very slow because we can’t do CTAS on entire big table in single transaction because of transaction limits and we end up doing in CTAS and with multiple insert statements . Which is very time consuming process
ASK: Please support column Rename
This feature is in Preview for columns in user tables.
Hi Jyoti, this was a recently identified defect during the preview. Documentation is being updated to reflect while the fix is being worked on. Thank you.
Jyoti Maheshwari commented
Does sp_rename work with tables which are not in dbo schema? If I am trying to rename a column in schema other than dbo, it throws an error.
Sujit Kadam commented
Any update on this feature?
Any update on this as of yet?
Bart Baeyens commented
I could not believe this is not implemented, such a basic feature??
Anu news when this will finally be available?
B H, Santosh commented
Any updates on this ?
Can we please know when will this feature/scenario be enabled. Its a pretty basic requirement - must have.
M Lam commented
Question - can it be achieved this way:
1) alter table add new column
2) update table set new column = old column
3) alter table drop old column