How to rename table column in sql server

One day in office, we were working with team for application testing. Suddenly we asked to rename the table column using t-sql command. In sql server, we can use sp_rename command to rename table, sp and column in database. Using below script you can change table name or column. sp_rename ‘tablename.[old_column_name]’, ‘New_column_name’,’Column’ example : if we want to ...