How to rename column in SQL with example

SQL Server SP_NAME  is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.