Alter Table

Alter Table

1. Rename Table

   • alter table name_table rename to new_name_table

2. Add column

   • alter table name_table add column name_column datatype

3. Drop Column

   • alter table name_table drop column name_column

4. Alter Column

   • alter table name_table alter column name_collumn datatype

5. Rename constraint

   • alter table name_table rename constraint "name_constraint" to new_name_constraint

6. Drop Constraint

   • alter table name_table drop constraint name_constraint

7. Add Primary Key

   • alter table name_table add primary key (name_primary key)

8. Add Constraint

   • alter table name_table add constraint name_constraint Unique name_column

9. Validate Constraint

   • alter table name_table validate constraint name_constraint

10. Add Constraint Foreign Key

    • alter table name_table add constraint name_constraint foreign key (name__column) references name_table (name_column_references)