将sql数据库字段char全部转换成varchar

--删除UQ约束

declare @string varchar(8000)

while exists(select name from sysobjects where xtype='UQ')

begin

 select top 1 @string= 'alter table ' +b.name+ ' drop constraint ' +a.name

  from (select parent_obj,name from sysobjects where xtype='UQ' ) a,

        (select id,name from sysobjects where OBJECTPROPERTY(id, N'IsUserTable')  = 1 ) b

    where a.parent_obj=b.id

 exec(@string)

end

go 

--默认值或 default 约束

declare  tb  cursor  for         

select sql = 'ALTER  TABLE ' +  t3.name   + ' DROP  CONSTRAINT ' +t4.name  +';' 

  from   syscolumns   t1,syscomments   t2,sysobjects   t3   ,sysobjects   t4   

    where     t1.cdefault=t2.id   and   t3.xtype='u'   and   t3.id=t1.id   

  and   t4.xtype='d'   and   t4.id=t2.id --and t1.length > 1 and t1.xtype = 175 

 

declare  @sql  varchar(1000)  

open  tb  

fetch  next  from  tb  into  @sql  

while  @@fetch_status  =  0  

begin  

           exec(@sql)  

           fetch  n