Explain Alter Table Command

Explain Alter Table Command.

- Alter Table command is a DDL command that is used to change the definition of the table.
- Changing definition means changing datatype, width of columns or adding a new column in the table.
- Use the ALTER TABLE statement to alter the definition of a nonpartitioned table, a partitioned table, a table partition, or a table subpartition.
- For object tables or relational tables with object columns, use ALTER TABLE to convert the table to the latest definition of its referenced type after the type has been altered.