用存储过程sp_rename

sp_rename [ @objname = ] 'object_name' ,
    [ @newname = ] 'new_name'
    [ , ][ @objtype = ] 'object_type' ]

具体操作请查看联机手册...