Horje
rename table sql Code Example
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 change table name 
ALTER TABLE exampletable RENAME TO new_table_name;
Source: www.bluehost.com
SQL query rename table 
EXEC sp_rename 'old_table_name', 'new_table_name'
Code language: SQL (Structured Query Language) (sql)
Source: www.sqlservertutorial.net
sql rename column 
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
modify column name in sql 
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);




Related
mysql show all tables Code Example mysql show all tables Code Example
mysql show tables in database Code Example mysql show tables in database Code Example
how to auto increment in sql Code Example how to auto increment in sql Code Example
get all table name in sql through php Code Example get all table name in sql through php Code Example
sql server substring Code Example sql server substring Code Example

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



 

Horje