sqlserver 批量修改表字段

--Script1:
--查看某数据库所有表的信息
DECLARE @tablespaceinfo TABLE (
    [name] SYSNAME,
    [rows] BIGINT,
    [reserved] VARCHAR(100),
    [data] VARCHAR(100),
    [index_size] VARCHAR(100),
    [unused] VARCHAR(100)
)

DECLARE @tablename VARCHAR(255);

DECLARE Info_cursor CURSOR FOR
    SELECT [name] FROM sys.tables WHERE TYPE='U';

OPEN Info_cursor
FETCH NEXT FROM Info_cursor INTO @tablename

WHILE @@FETCH_STATUS = 0
BEGIN
	IF LEFT(@tablename,10) ='Customers_'
	BEGIN
	--添加的SQL语句
	DECLARE @alertSql VARCHAR(2048);
	SET @alertSql = CONCAT(
	'ALTER TABLE [',
	@tablename,
	'] ADD ',
	' WorkOrderId uniqueidentifier null; '
	);	
	--输出SQL语句
	PRINT @alertSql
	--执行SQL语句
	EXEC (@alertSql);
	END		
    
    FETCH NEXT FROM Info_cursor INTO @tablename
END

CLOSE Info_cursor
DEALLOCATE Info_cursor