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

9 votes94 views2 answers
Get first 3 letters in sql
SQL
1 vote107 views1 answer
Median mysql
SQL
1 vote118 views1 answer
Oracle sql pad left zeros
SQL
0 vote96 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote99 views1 answer
Mysql select all table that have field names
SQL
12 votes161 views2 answers
Update column data type postgres
SQL
0 vote105 views1 answer
MySQL INSERT IGNORE Statement
SQL
8 votes106 views6 answers
Sql insert
SQL
8 votes98 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote100 views1 answer
Create schema sql server
SQL