In order to rename the smart field, the smart field must be removed from the adhoc query(ies) using it as a filter or output field. To find queries using smart fields, run the script below in SQL Server Management Studio. The script can be modified to search for queries using a specific smart field.

select * from adhocquery where
cast(querydefinitionXML as nvarchar(max)) like '%Smart Field%'

The script can be modified to search for queries using a specific smart field. For example, if looking for only the queries using a smart field called BBSupport Constituent Smart Field, run the script below:

select * from adhocquery where
cast(querydefinitionXML as nvarchar(max)) like '%BBSupport Constituent Smart Field%'