Question

How is ALTER TABLE statement different from CREATE TABLE statement ?

Answer 1

•The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

•The CREATE TABLE Statement is used to create tables to store data. Integrity Constraints like primary key, unique key, foreign key can be defined for the columns while creating the table. The integrity constraints can be defined at column level or table level.

Hope it works out for you.

Regards,

Smruti.