Procedure documentationChanging Table Properties Locate this document in the navigation structure

 

You use the table editor to change table properties.

Note Note

To change table properties, you can also use SQL statements instead of the table editor.

More information:

End of the note.

Prerequisites

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

  • You have the ALTER privilege for the table.

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

    More information: Creating Tables

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

More Information

Creating Tables