如何将每个 nvarchar 列更改为 varchar? [英] How to change every nvarchar column to varchar?

问题描述

将数据库中的每个 nvarchar 列更改为 varchar 的最简单方法是什么?

what would be the simplest way to change every nvarchar column in a database to a varchar?

我个人更喜欢 nvarchar，但数据架构已指定必须使用 varchar.

I personally would prefer nvarchar, but the data arch has specified that varchar must be used.

推荐答案

这里，让你开始:

Select 'Alter Table [' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] Alter Column [' + COLUMN_NAME + '] VarChar(' + CAST(CHARACTER_MAXIMUM_LENGTH As VARCHAR) + ')'
From INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE = 'NVARCHAR'

这将为您生成所有需要的更改语句(剪切、粘贴、运行).

This will generate all the needed alter statements for you (cut, paste, run).

请注意，这没有考虑任何限制.

Note that this does not take any constraints into account.

这篇关于如何将每个 nvarchar 列更改为 varchar?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！