ALTER TABLE (Column)

Purpose

Use this to add, drop, change the data type, rename a column, or to define default values and column identities.

Prerequisites

You need to have the system privilege ALTER ANY TABLE, object privilege ALTER on the table or its schema, or the table belongs to the current user or assigned one of the user roles.