• 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