Use this wiki to look for (or add) T-SQL scripts you find useful.
sp_rename 'OriginalTableName', 'NewTableName'
sp_rename 'TableName.OriginalColumnName', 'NewColumnName'