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.
|