Rename column sql

Rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;

Sql rename column

-- Oracle, MySQL 8+
ALTER TABLE table_name RENAME COLUMN current_name TO new_name;
-- MySQL < 8:
ALTER TABLE table_name CHANGE current_name new_name datatype(length);
-- SQL Server:
EXEC SP_RENAME 'table_name.current_name' , 'new_name', 'COLUMN'

Change column names mssql

--The following example renames the column TerritoryID in the table Sales.SalesTerritory to TerrID in the AdventureWorks database.

EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';

Sql rename column

EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

Rename column sql

ALTER TABLE nom_table
RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom

Source: sql.sh

Cmd to rename a collumn name in sql

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

Similar codes

11 votes129 views1 answer
Sql query to find duplicates in column
SQL
1 vote154 views1 answer
How to get alternate records from a table in sql
SQL
1 vote134 views1 answer
Mysql show queries running
SQL
0 vote128 views1 answer
Sqlite update only if greater
SQL
0 vote133 views1 answer
Get substract count sql
SQL
1 vote139 views2 answers
Sql insert timestamp
SQL
2 votes116 views1 answer
Wait delay in sql server
SQL
3 votes154 views1 answer
Apex set debug level
SQL
0 vote117 views1 answer
SQL Server format datetime
SQL
1 vote138 views1 answer
Psql import backup file for windows
SQL