Horje
sql rename column Code Example
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';
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'
sql rename column 
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
cmd to rename a collumn name in sql 
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
modify column name in sql 
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);



Sql

Related
database dump mysql command Code Example database dump mysql command Code Example
mysql trim whitespace Code Example mysql trim whitespace Code Example
mysql slave status Code Example mysql slave status Code Example
t sql get foreign key Code Example t sql get foreign key Code Example
how to drop a database in sql server when it is in use Code Example how to drop a database in sql server when it is in use Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje