How to Rename a Column Name or Table Name in SQL SERVER

Table Name Rename :

Command: SP_RENAME 'TableOldName', 'NewTableName'

Column Name Rename :

Command: SP_RENAME 'TableName.[ColumnOldName]', '[NewColumnName]'

References: http://msdn.microsoft.com/en-us/library/aa238878%28v=sql.80%29.aspx