Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do this with the help of the Exec Sp_rename command. The Syntax of the Sp_rename is given below:- Exec sp_rename ‘TableName.[OldColumnName]’, ‘[NewColumnName]’, ‘Column’ For example, suppose we have a table called Employee who has the following structure:- […]
Continue Reading