rename table or column in MSSQL

Code

1. To rename table,

EXEC sp_rename 'OldTableName', 'NewTableName'

2. To rename column,

EXEC sp_rename
@objname = 'TableName.OldColumnName',
@newname = 'NewColumnName',
@objtype = 'COLUMN'

References

http://yawcerng.blogspot.com/2010/06/ms-sql-rename-table.html