DECLARE @tableName NVARCHAR(128) = 'yourtablename'
DECLARE @sql NVARCHAR(MAX) = ''
SELECT @sql = @sql + 'EXEC sp_rename ''' + @tableName + '.' + COLUMN_NAME + ''', ''' + LOWER(COLUMN_NAME) + ''', ''COLUMN'';'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tableName
EXEC (@sql)
sqlserver中用sql将表中每个字段转为小写字母
![](https://img-home.csdnimg.cn/images/20240711042549.png)