Using below link we wrote a query to rename the column name in Azure SQL Data warehouse
https://docs.microsoft.com/en-us/sql/t-sql/statements/rename-transact-sql?view=aps-pdw-2016-au7#:~:text=Renames%20a%20user%2Dcreated%20table%2C%20a%20column%20in%20a%20user,(Azure%20SQL%20Database)%20statement.
rename object tablename column Col1 to Col2;
when we ran the above query it is throwing error message Incorrect Syntax near 'Column'
and also we ran a different query
Alter table tablename rename column Col1 to Col2;
the above query giving error message like Incorrect syntax near 'Rename'


