Some times you may receive instructions from you DBA’s to change your database collation (which implies to propagate the change to the column level collation).…