Most objects can be renamed by simply right clicking on it's name in the Database Tab and selecting "Rename".
The old name will be displayed and selected in case you just want to modify the existing name.
Objects can also be renamed from their respective editor dialog.