Using ALTER command, you can add a column to a table. Using ALTER command, you can perform the following operations −
![alter table add column alter table add column](https://i.ytimg.com/vi/8yAaO_ySTkw/maxresdefault.jpg)
Given below is the syntax for creating a table. For more information, refer to the Identity Columns section.You can alter a table using the command ALTER TABLE. By the use of this command, you can also "reset" the number generator.
#Alter table add column plus
Starting with the number specified plus one, monotonically increasing numbers are generated for INSERT statements, which do not insert an explicit value to the identity column.
#Alter table add column generator
![alter table add column alter table add column](https://razorsql.com/images/features/oracle_add_column.jpg)
If the column that is dropped is a part of the partitioning key (see ALTER TABLE (distribution/partitioning) for more information), then the partitioning keys are dropped and the new rows of the table will not be partitioned any more.If the column that is dropped is a part of the distribution key (see ALTER TABLE (distribution/partitioning) for more information), then the distribution keys are dropped and the new rows of the table will be distributed randomly across the cluster nodes.When you specify this option, the foreign key reference to the column is deleted even when the referencing table does not belong to the current user.
![alter table add column alter table add column](https://www.red-gate.com/simple-talk/wp-content/uploads/imported/1832-AlterTableColumnBig.png)