Altering a nickname

A nickname is an identifier references an object that you want to access at a data source.

Before you begin

Ensure that the authorization ID of the statement includes at least one of the following:
  • SYSADM or DBADM authority
  • ALTER privilege on the nickname that is specified in the statement
  • CONTROL privilege on the nickname that is specified in the statement
  • ALTERIN privilege on the schema, if the schema name of the nickname exists
  • Definer of the nickname as recorded in the DEFINER column of the catalog view for the nickname

About this task

You might want to alter a nickname for the following reasons:
  • To alter the local column names for the columns of the data source object
  • To alter the local data types for the columns of the data source object
  • To add, set, or drop nickname and column options
  • To add or drop a primary key
  • To add or drop one or more unique, referential, or check constraints
  • To alter one or more referential, check, or functional dependency constraint attributes

Procedure

Use one of the following methods:

  • Command line:

    Issue the ALTER NICKNAME statement.

    When the data source object structure or content changes significantly, you should update the nickname statistics. Significant changes include the addition or removal of multiple rows.

  • Web console:
    1. Click Administer > Remote Tables.
    2. Click a nickname.
    3. Click Alter.