Collation change on existing database
-
Hi all. Here is my latest question:
I have a server that has several databases on it all with the Latin collation. The Dev team has imported a database used in another application and it has Swedish collation. My optimization and integrity job keeps failing do to a table with a computed column. What I have read, says I can alter the tables, but I want to alter the entire database back to Latin collation.
Can you help me with issues I will encounter? Can I do the entire db or is it a table by table alter?
Thank you in advance as always, for the help, I appreciate it tons!!
-
When you change the default collation of a database, it only affects newly created tables. There is also a default collation for a table. Then, the collation is set at the column level. If you don't have a lot of tables, you could manually change each column on each table. The table is dropped and recreated when you change the collation of the columns.
Another option would be to script out the table definitions, remove the collation designation and play the script. Then you would have to import the data from another copy of the database. This could be a big headache if you have foreign key constraints or triggers which would have to be applied later.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply