ALTER TABLE Statement

ALTER TABLE Statement :

• Use the ALTER TABLE statement to :
  – Add a new column
  – Modify an existing column
  – Define a default value for the new column
  – Drop a column

Dropping a Table :

• All data and structure in the table are deleted.
• Any pending transactions are committed.
• All indexes are dropped.
• All constraints are dropped.
• You cannot roll back the DROP TABLE statement.
• DROP TABLE dept30;