命名

https://www.cnblogs.com/xilipu31/archive/2013/05/02/3054641.html

 

SELECT 

'EXECUTE sp_rename N''dbo.'+d.name+'.'+a.name+''', N'''+dbo.fn_GetPy(convert(varchar, ISNULL(g.[value], '')))+CONVERT(nvarchar(50),a.colorder)+''', ''COLUMN''' 

FROM dbo.syscolumns a LEFT OUTER JOIN
      dbo.systypes b ON a.xtype = b.xusertype INNER JOIN
      dbo.sysobjects d ON a.id = d.id AND d.xtype = 'U' AND
      d.status >= 0 LEFT OUTER JOIN
      dbo.syscomments e ON a.cdefault = e.id LEFT OUTER JOIN
      sys.extended_properties g ON a.id = g.major_id AND a.colid = g.minor_id AND
      g.name = 'MS_Description' LEFT OUTER JOIN
      sys.extended_properties f ON d.id = f.major_id AND f.minor_id = 0 AND
      f.name = 'MS_Description'
      where a.name<>'ID'