查询表字段类型长度

use '数据库名'

declare @sql varchar(8000),@n int,@max int,@table varchar(30),@field varchar(20),@leng varchar(10)

set @sql=''

set @n=1

set @max=0

set @table='表名'

drop table tabletemp

select ID=identity(int,1,1),,field=,ftype=,leng=c.length

into tabletemp

from syscolumns c

inner join sysobjects o on o.id=c.id and o.xtype='u'

inner join systypes t on c.xtype=t.xtype

where ='char'

and like +@table+'%'

set @max=(select max(ID) from tabletemp)

while @n<=@max

begin

select @table=name,@field=field,@leng=leng from tabletemp where id=@n

set @sql=' alter table '+@table+' alter '+@field+' varchar('+@leng+') go'

set @n=@n+1

select @sql,@table,@field,@leng

end