Rename Statistics

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

You can rename a statistics object in SQL Server by using Transact-SQL

In This Topic

• Before you begin:

  Limitations and Restrictions

  Security

• To rename a statistics object, using:

  Transact-SQL

Before You Begin

Limitations and Restrictions

By default, creating an index creates a statistic on the key columns of that index. Therefore, renaming the index automatically renames the statistics object, and vice versa.

Changing any part of an object name can break scripts and stored procedures. Instead of renaming, we recommend that you drop the statistics object and re-create it with the new name.

Security

Permissions

Requires ALTER permission on the table or view.

Using Transact-SQL

To rename a statistics object

1. In Object Explorer, connect to an instance of Database Engine.

2. On the Standard bar, click New Query.

3. Copy and paste the following example into the query window and click Execute.

   USE AdventureWorks2022;  
   GO  
   EXEC sp_rename N'AK_Employee_LoginID', N'AK_Emp_Login', N'STATISTICS';   
   GO  
   

For more information, see sp_rename (Transact-SQL).