Oracle alter table

Alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

Add column table pl sql

ALTER TABLE table_name
  ADD column_name column_definition;

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

Oracle alter table

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

Source: oracletutorial.com

Alter table oracle

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

Source: techonthenet.com

Similar codes

0 vote246 views1 answer
Query by column for substring sql
SQL
2 votes241 views1 answer
Mysql clear screen
SQL
2 votes234 views1 answer
Postgresql drop primary key constraint
SQL
0 vote243 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
2 votes247 views5 answers
SQL trigger
SQL
8 votes242 views1 answer
Oracle tablespace datafile max size
SQL
0 vote248 views1 answer
Mysql bind-address default value
SQL
0 vote226 views1 answer
Select count postgres double row count > 1
SQL
4 votes236 views3 answers
Drop Table Oracle
SQL
13 votes229 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL