Convert all NCHAR columns to NVARCHAR columns in a database or table
===

I have a database that contains a lot of `NCHAR(n)` columns. Some of these columns are simple properties, but some are also primary-keys or foreign keys.

There are many tables and columns and a huge amount of test data.

What is the best way to convert every `NCHAR(n)` column to a `NVARCHAR(n)` column of the same length and trim its content while doing so?

If you can think of anything better than changing the column in the designer, remembering the column name and trimming it in a script window, please post it as an answer.