Rename a Table/Column

CREATE TABLE OLD_TABLE (ID INT, NAME VARCHAR(10))

--To rename a table

EXEC SP_RENAME

@OBJNAME= 'TABLE_NAME',

@NEWNAME = 'NEW_TABLE_NAME'

Eg:

EXEC SP_RENAME

@OBJNAME= 'OLD_TABLE',

@NEWNAME = 'NEW_TABLE'

or

EXEC SP_RENAME 'OLD_TABLE', 'NEW_TABLE'

--To rename a column in a table

EXEC SP_RENAME

@OBJNAME= 'NEW_TABLE.ID',

@NEWNAME = 'NEW_ID',

@OBJTYPE = 'COLUMN'

or

EXEC SP_RENAME 'NEW_TABLE.ID', 'NEW_ID','COLUMN'