更新整个库中所有表的指定字段名称

更新整个库中所有表的指定字段名称

Create proc ReAllColName(@OldColName varchar(100),@NewColName varchar(100))
as
Declare @TableName varchar(200)
Declare @TempName  varchar(300)
Declare Cur_ReCol Cursor Fast_forward For

Select Object_name(Id) From Syscolumns Where [Name]=@OldColName

Open Cur_ReCol
Fetch From Cur_ReCol Into @TableName
While @@Fetch_status=0
Begin
 Set  @TempName=@tableName+'.'+@OldColName
 Exec sp_rename @TempName,@NewColName,'COLUMN'
 Fetch From Cur_ReCol Into @TableName
END
Close Cur_ReCol
Deallocate Cur_ReCol
GO

 

reallcolname '旧列名称','新列名称'