SQL 批量修改表结构

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

项目中发现一批语言表的某个字段设的值太小了需要增大，因为涉及到很多张表，所以采用游标一张张的处理。

代码很简单

DECLARE @tableName NVARCHAR(50)

DECLARE @sql NVARCHAR(200)

DECLARE LangTable CURSOR FOR

SELECT name  FROM sys.tables WHERE name LIKE '%Language'

    OPEN LangTable

    FETCH NEXT FROM LangTable INTO @tableName

    WHILE @@FETCH_STATUS = 0

    BEGIN

    SET @sql = 'ALTER TABLE  '+@tableName+' ALTER COLUMN LanguageDesc NVARCHAR(MAX)'

    EXEC @sql

    FETCH NEXT FROM LangTable INTO @tableName

    END

CLOSE LangTable

DEALLOCATE LangTable