locked
How to change collation for Azure SQL Data warehouse and Azure SQL Database? RRS feed

  • Question

  • Hi Guy,

    Can i change sql collation for Azure SQL Data warehouse and Azure SQL Database form Latin to another collation in exiting resource?

    Who can help and recommend me about my issue. please help suggestion me.

    Thanks,

    za_phu

    Thursday, June 6, 2019 3:51 PM

All replies

  • There is no direct way to change the collation for Azure SQL Database and Azure SQL Datawarehouse once they are created.

    Do you need to change the collation on specific columns or the entire database.

    You can change it on individual columns using the script below

    ALTER TABLE dbo.MyTable ALTER COLUMN CharCol  
                varchar(10)COLLATE YOURTARGETCOLLATION NOT NULL;  
    GO  
    

    However if you need to change it on the entire database, you can do it via a .bacpac file.

    Please refer to the instructions here

    Do let me know if you have further questions.

    Friday, June 7, 2019 5:03 AM
  • Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know. 
    Thursday, June 13, 2019 2:03 PM