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

3 votes198 views1 answer
Async await mysql nodejs
SQL
2 votes246 views3 answers
Mysql kill
SQL
6 votes186 views1 answer
Phpmyadmin reset root password
SQL
3 votes149 views4 answers
Show columns from table
SQL
0 vote201 views1 answer
Oracle running queries sql
SQL
2 votes209 views1 answer
Drop sequence
SQL
0 vote197 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
5 votes196 views2 answers
Mysql import gzip db
SQL
9 votes214 views6 answers
Oracle substring
SQL
1 vote271 views2 answers
Sql example query
SQL