Applies To: SQL Server 2016
You can modify existing statistics in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.
In This Topic
The user has ALTER permission on the table or view.
The user be the table or indexed view owner, or a member of one of the following roles: sysadmin fixed server role, db_owner fixed database role, or the db_ddladmin fixed database role.
In Object Explorer, click the plus sign to expand the database in which you want to modify a statistic.
Click the plus sign to expand the Tables folder.
Click the plus sign to expand the table in which you want to modify a statistic.
Click the plus sign to expand the Statistics folder.
Right-click the statistics object that you wish to modify and select Properties.
In the Statistics Properties - statistics_name dialog box, on the General page, click Add, Remove, Move Up, or Move Down, or any combination, to alter the properties of the statistics. Remember that a column’s location within the Statistics Columns grid can substantially impact the usefulness of the statistics.
To modify statistics
This task cannot be performed using Transact-SQL statements. To modify statistics using Transact-SQL, you must first delete the existing statistic and then re-create it with new attributes.