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

4 votes206 views1 answer
Sql quote in string
SQL
0 vote204 views1 answer
Can we rollback data that are deleted using DELETE
SQL
57 votes585 views6 answers
Mysql alter table add column
SQL
10 votes200 views3 answers
Sql select between two dates
SQL
2 votes291 views1 answer
Sql missing records from another table
SQL
0 vote257 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote199 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote216 views1 answer
For row in sql database python loop
SQL
1 vote190 views2 answers
Mysql current user
SQL
0 vote192 views1 answer
Services.AddDbContext DataSource Sqlite
SQL