recreating whole SQL Server Database with relations -

I used SQL Server 2012 and made a huge database with many links. Today, I realized the use of "NCHAR" instead of "NVHAR" which adds space on the end of the strings which I do not like. What is the procedure for reproducing the database with relationships? I have tried to "drop and make" tables, but all relationships need to be removed and redefined which is very time consuming.

"post-text" itemprop = "text">

Is it possible to change only the affected tables? By the way:

  SELECT 'alter table' + s.name + '.' + T.name + 'column' + c.name + 'nvarchar (' + convert (varchar (11), c .max_length / 2) + ') as t' t internal association sys.schemas t [Schema_id] = s [schema_id] internal association sys.column c as C. [Object_id] = c. [Object_id] and c.system_type_id = 239 - nchar type   
, and before that to avoid extra spaces, make sure to use the same type of mechanism to generate an update statement .