exec sp_msforeachtable
@whereand=' and exists(select * from syscolumns where id=o.id and name=''编号'' and xusertype=175 and prec=10)',
@command1='alter table ? alter column 编号 varchar(20)'
exec sp_msforeachtable
@whereand=' and exists(select * from syscolumns where id=o.id and name=''编号'' and xusertype=175 and prec=10)',
@command1='alter table ? alter column 编号 varchar(20)'