How to rename Column Name and Table Name?

We can use sys.SP_Rename procedure to rename the column and table in SQL Server.

CREATE TABLE empl
(
name VARCHAR(20),
remarks VARCHAR(100)
)


--syntax to rename column
EXEC sys.Sp_rename
@objname = 'table_name.old_column_name',
@newname = 'new_column_name',
@objtype = 'COLUMN'

--rename column example
EXEC sys.Sp_rename
@objname = 'empl.name',
@newname = 'empname',
@objtype = 'COLUMN'

--rename table name Old Table Name and New Table Name
EXEC sys.Sp_rename
'empl',
'empInfo'

EXEC sys.Sp_rename