{"id":1773,"date":"2019-04-19T16:00:15","date_gmt":"2019-04-19T09:00:15","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1773"},"modified":"2024-03-14T15:47:13","modified_gmt":"2024-03-14T08:47:13","slug":"sql-server-rename-index","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-indexes\/sql-server-rename-index\/","title":{"rendered":"SQL Server Rename Index"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to rename an index using the system stored procedure sp_rename<\/code> and SQL Server Management Studio.<\/p>\n\n\n\n

Renaming an index using the system stored procedure sp_rename #<\/a><\/h2>\n\n\n\n

The sp_rename<\/code> is a system stored procedure that allows you to rename any user-created object in the current database including table, index, and column.<\/p>\n\n\n\n

The statement renames an index:<\/p>\n\n\n

EXEC sp_rename \n    index_name, \n    new_index_name, \n    N'INDEX';  \n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
or you can use the explicit parameters:<\/p>\n\n\n
EXEC sp_rename \n    @objname = N'index_name', \n    @newname = N'new_index_name',   \n    @objtype = N'INDEX';\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
For example, the following statement renames the index ix_customers_city<\/code> of the sales.customers<\/code> table to ix_cust_city<\/code>:<\/p>\n\n\n
EXEC sp_rename \n        @objname = N'sales.customers.ix_customers_city',\n        @newname = N'ix_cust_city' ,\n        @objtype = N'INDEX';\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
or in short:<\/p>\n\n\n
EXEC sp_rename \n        N'sales.customers.ix_customers_city',\n        N'ix_cust_city' ,\n        N'INDEX';\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Renaming an index using the SQL Server Management Studio (SSMS) #<\/a><\/h2>\n\n\n\n
To change the name of an index to the new one using the SSMS, you follow these steps:<\/p>\n\n\n\n
First, navigate to the database, table name, and indexes:<\/p>\n\n\n\n
Second, right-click on the index to which you want to change the name and choose the rename<\/strong> menu item. In the following picture, we will rename the index ix_customers_name<\/code> of the sales.customers<\/code> table:<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
Third, type the new name and press enter. The following picture shows the ix_customers_name<\/code> index change to ix_cust_fullname<\/code>:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
In this tutorial, you have learned how to rename an index using sp_rename<\/code> stored procedure and SQL Server Management Studio.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t