Rename column in SQL Server

Solution 1:

EXEC sp_rename 'Categories.Active', 'CategoriesActive', 'COLUMN'

Solution 2:

FOR MSSQL :

EXEC sp_rename 'TABLENAME.OLD_COLUMNNAME', 'NEW_COLUMNAME', 'COLUMN';

FOR MYSQL : Use ALTER TABLE to do this

ALTER TABLE tbl_name CHANGE [COLUMN] old_col_name new_col_name

You can rename a column using a CHANGE old_col_name new_col_name column_definition clause. To do so, specify the old and new column names and the definition that the column currently has. For example, to rename an INTEGER column from a to b, you can do this:

ALTER TABLE t1 CHANGE a b INTEGER;

Solution 3:

You don't need to use that select in front, and the syntax should be like:

EXEC sp_rename 
    @objname = 'Categories.Active', 
    @newname = 'CategoriesActive', 
    @objtype = 'Type_of_your_column'