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;

ALTER TABLE order_details
  DROP COLUMN notes;

ALTER TABLE order_details
  RENAME TO order_information;

PREVIOUS	NEXT

Code Example
Sql :: delete database mysql
Sql :: psql get sequences
Sql :: postgres get month name from date
Sql :: customer using hdfc bank sql query
Sql :: mysql remove last character
Sql :: sql alter table add column if exists
Sql :: mssql show database size
Sql :: how to get list of synonyms in oracle
Sql :: get hour from date sql
Sql :: mysql list users on ubuntu
Sql :: status mysql
Sql :: how to update date add hours in postgresql
Sql :: how to add a index to live table sql
Sql :: Create a keyspace cassandra
Sql :: ver usuarios mysql
Sql :: sql pick random row
Sql :: get table column names sql ssms
Sql :: influxdb export to csv
Sql :: oracle sql query to make column data uppercase
Sql :: check database size sql
Sql :: mysql get count of rows
Sql :: select from one table where not on the other
Sql :: how to start mysql in terminal mac
Sql :: sql syntax find few columns
Sql :: postgresql division count return 0
Sql :: check mysql version phpmyadmin
Sql :: list index mysql cli
Sql :: how to insert into existing database postgresql sqlalchemy python
Sql :: laravel paginate raw sql
Sql :: SQL server query column yes or no