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

15 votes190 views4 answers
How to get all tables in sql
SQL
6 votes188 views1 answer
How to count number of rows in sql
SQL
0 vote192 views1 answer
Pl/ sql change currency
SQL
4 votes201 views1 answer
W3schools create table
SQL
0 vote167 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
31 votes189 views3 answers
Sql count
SQL
2 votes195 views1 answer
Set username and password for postgresql database
SQL
0 vote207 views1 answer
What is database username and password in mysqliconnect
SQL
2 votes193 views1 answer
Get hour from date sql
SQL
0 vote200 views2 answers
Athena drop partition
SQL