I got a table named tblHello and I wanna rename it to Hello
Right click on the table and select rename in management studio You can also use sp_rename:
sp_rename 'old_table_name', 'new_table_name'