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

3 votes119 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote114 views1 answer
Sql create table with datetime automatically
SQL
2 votes106 views1 answer
Postgresql add entry to table
SQL
0 vote124 views1 answer
Sql filter rows with condition
SQL
3 votes115 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote99 views1 answer
Sql select lowest value row
SQL
0 vote178 views1 answer
Trigger
SQL
12 votes113 views2 answers
Delete all entries postgres
SQL
0 vote108 views1 answer
What is metadata in sql
SQL
0 vote112 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL