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

31 votes153 views3 answers
SQL Server change column data type
SQL
0 vote145 views1 answer
Access refused mysql xampp server
SQL
1 vote144 views1 answer
Ilike for date postgres
SQL
6 votes157 views2 answers
Postgresql database url
SQL
0 vote151 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote233 views1 answer
Oracle datafile max size 32gb
SQL
14 votes152 views5 answers
Sql oracle limit
SQL
0 vote154 views1 answer
Mysql create index lost connection
SQL
0 vote148 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote152 views1 answer
Mysql procedure between two tables
SQL