Alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

PL SQL MODIFY COLUMN NME

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;

Alter table oracle

ALTER TABLE table_name
ADD CONSTRAINT constraint_name
   FOREIGN KEY (column1, column2, ... column_n)
   REFERENCES parent_table (column1, column2, ... column_n);

Source: techonthenet.com

Alter table oracle

ALTER TABLE products
ADD CONSTRAINT fk_supplier
  FOREIGN KEY (supplier_id)
  REFERENCES supplier(supplier_id);

Source: techonthenet.com

Oracle alter table

ALTER TABLE table_name 
ADD column_name data_type constraint;
Code language: SQL (Structured Query Language) (sql)

Source: oracletutorial.com

Similar codes

0 vote264 views1 answer
Codeigniter dbforge add index
SQL
0 vote291 views3 answers
How to increase size of column in sql
SQL
0 vote298 views2 answers
Mysql show foreign keys
SQL
24 votes257 views5 answers
Sql reset auto increment
SQL
9 votes253 views3 answers
Mysql get last id
SQL
1 vote249 views1 answer
Update from select join
SQL
-1 vote223 views2 answers
Datetime sql server week
SQL
0 vote258 views1 answer
Output to file mysql
SQL
4 votes269 views2 answers
Mysql how to change default charset
SQL
2 votes270 views2 answers
Mamp connect mysql terminal
SQL