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 vote155 views1 answer
Sql server count all tables rows
SQL
7 votes147 views3 answers
How ot change name of column mysql
SQL
2 votes152 views1 answer
Oracle drop table free up space
SQL
5 votes174 views2 answers
Postgresql insert select
SQL
0 vote153 views1 answer
Suse start MySQL
SQL
0 vote140 views1 answer
Inser into example
SQL
0 vote160 views1 answer
Load utilities in sql server
SQL
0 vote168 views1 answer
Mysql join column order By and group By
SQL
15 votes160 views3 answers
Find duplicate keys in mysql
SQL
1 vote159 views3 answers
Reset sql primary key
SQL