Procedure documentationChanging Column Properties Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You are the owner of the table or have the ALTER privilege for the table to which the column belongs.

    More information: SQL Reference Manual, Privilege Specification (priv_spec)

  • The database is in the ONLINE operational state.

Procedure

  1. Select the table in the explorer tree.

  2. In the context menu of the table, choose Definition

    Note Note

    To display the definition as an SQL statement, choose Export SQL in the context menu of the editor window.

    End of the note.

  3. In the context menu of the editor window, choose Edit

  4. Change the column definition.

    More information: SQL Reference Manual,

  5. In the context menu of the editor window, choose Alter Table.

More Information

SQL Reference Manual, ALTER TABLE Statement (alter_table_definition)