Tag: SP_Rename

  • 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