Modify Statement
The modify statement changes properties of a table or index.
This statement has the following syntax:
modify [schema.]table_name|[schema.]indexname |
[ schema.]table-name
to modify-action [unique]
[on column_name [asc|desc]{, column_name [asc|desc]}]
[with_clause];