Sql

ALTER TABLE customers 
RENAME COLUMN name TO customer_name;

ALTER TABLE customers
RENAME COLUMN phone TO contact_phone;

ALTER TABLE table_name
RENAME TO new_table_name;

ALTER TABLE table_name 
RENAME COLUMN column_name TO new_column_name;

ALTER TABLE distributors RENAME COLUMN address TO city;

PREVIOUS	NEXT

Code Example
Sql :: mysql case when or
Sql :: oracle nextval
Sql :: mysql change password
Sql :: mysql drop database
Sql :: datediff
Sql :: phpmyadmin change password
Sql :: create stored procedure
Sql :: sql update table set text to lowercase
Sql :: sql server output parameter
Sql :: select last row in sql
Sql :: check duplicate values plsql
Sql :: sql update where id
Sql :: sequelize migration default value
Sql :: create temporal table in sql
Sql :: greater than in mongodb query
Sql :: change mysql version to 5.7 in ubuntu
Sql :: get first monday of month sql
Sql :: connexion mysql
Sql :: sql all columns
Sql :: how to extract only year and month from date in sql
Sql :: drop column from local database postgres pgadmin
Sql :: how to delete the rows with null values in mysql
Sql :: mysql update two tables at once
Sql :: 3rd highest value in sql
Sql :: Postgres - Login and connect as default user
Sql :: sql extract from mail
Sql :: mysql declare variable
Sql :: mysql execute file
Sql :: mysql delete rows
Sql :: mysql load sql from file