Sql

ALTER TABLE customers 
RENAME COLUMN name TO customer_name;

ALTER TABLE customers
RENAME COLUMN phone TO contact_phone;

ALTER TABLE table_name 
RENAME COLUMN column_name TO new_column_name;

ALTER TABLE distributors RENAME COLUMN address TO city;

ALTER TABLE order_details
  DROP COLUMN notes;

ALTER TABLE order_details
  RENAME TO order_information;

PREVIOUS	NEXT

Code Example
Sql :: add current timestamp in mysql
Sql :: select nextval from sequence sql
Sql :: drop table if exists test
Sql :: oracle list columns in schema
Sql :: mysql create view full table
Sql :: phpmyadmin reset root password
Sql :: mysql check datetime equals date
Sql :: nested if in mysql
Sql :: ms sql print from new line
Sql :: sql select last id
Sql :: remove user and their privileges postgres
Sql :: sql current timestamp table
Sql :: mysql show views
Sql :: mysql disable query caching
Sql :: zsh-syntax-highlighting zsh-autosuggestions
Sql :: mysql isnull
Sql :: sql count number of rows after group by
Sql :: check lock on table in sql server
Sql :: laravel general error 2006 mysql server has gone away
Sql :: SQL NOT BETWEEN Operator
Sql :: How can I tell how many Cores SQL Server is actually using?
Sql :: drop all tables in azure sql database
Sql :: db.relationship sqlalchemy flask
Sql :: mysql export database command line
Sql :: sql if empty then
Sql :: mysql timestamp format
Sql :: sql reverse order of results
Sql :: sql format time
Sql :: sql server phone constraint
Sql :: create scalar function in sql server