Search
 
SCRIPT & CODE EXAMPLE
 

SQL

rename column postgres

ALTER TABLE customers 
RENAME COLUMN name TO customer_name;

ALTER TABLE customers
RENAME COLUMN phone TO contact_phone;
Comment

rename table postgres

ALTER TABLE table_name
RENAME TO new_table_name;
Comment

rename table column postgresql

ALTER TABLE table_name 
RENAME COLUMN column_name TO new_column_name;
Comment

rename column postgres

ALTER TABLE distributors RENAME COLUMN address TO city;
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql search all tables for column name 
Sql :: postgresql concatenate multiple rows in group by 
Sql :: oracle drop column 
Sql :: postgres DROP and create contraint 
Sql :: cast to date bigquery 
Sql :: postgres restart id 
Sql :: name of today sql 
Sql :: how to add a index to live table mysql 
Sql :: netstat -tln mysql 
Sql :: how to create index mysql 
Sql :: use cases condition in sql query laravel 
Sql :: get columns number sql 
Sql :: raw query must include primary key 
Sql :: mysql set field unique 
Sql :: mysql password error create datbase 
Sql :: postgres drop column if exists 
Sql :: generate random data postgresql 
Sql :: sql find column name like 
Sql :: sql command to find foreign key references 
Sql :: oracle aleter trigger ora-01031 
Sql :: oracle get trigger ddl 
Sql :: scaffold npgsql net core 
Sql :: mysql disable foreign keys check 
Sql :: how to use a trigger to validate input data 
Sql :: distincct sql 
Sql :: how do you use sql in you company 
Sql :: postgresql difference between two dates in days 
Sql :: plsql code for deleting a row from nested table in oracle 
Sql :: find nth highest salary of an employee 
Sql :: mysql login console 
ADD CONTENT
Topic
Content
Source link
Name
2+8 =