You can rename indexes and other objects:
use pubs
if object_ID('test_rename_HIS') is not null drop table test_rename_HIS
if object_ID('test_rename_ARC') is not null drop table test_rename_ARC
create table test_rename_HIS
(ID int Not Null constraint PK_HIS Primary Key,
Name varchar(255))
go
create index I_HIS on test_rename_HIS (Name)
go
exec sp_rename
@objname = 'test_rename_HIS' ,
@newname = 'test_rename_ARC' ,
@objtype = 'Object'
go
exec sp_rename
@objname = 'PK_HIS' ,
@newname = 'PK_ARC' ,
@objtype = 'Object'
go
exec sp_rename
@objname = 'test_rename_ARC.I_HIS' ,
@newname = 'I_ARC' ,
@objtype = 'Index'
go
DBCC FREEPROCCACHE
Signature is NULL