sql server字段大小修改为小写 

SELECT 'EXEC sp_rename     @objname = ''' + TABLE_NAME + '.' + COLUMN_NAME + ''',     @newname = ''' + LOWER( COLUMN_NAME ) + ''',     @objtype = ''COLUMN''' 
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME='tb_xxx'

　　

posted @ 2016-08-21 17:59  lobtao  阅读(970)  评论(0)  编辑  收藏  举报