Errors and Warnings from alter table

Most errors you encounter when running alter table inform you of schema constructs that prevent the requested command (for example, if you try to drop a column that is part of an index).

To report error conditions:
  1. Set showplan on.
  2. Set noexec on.
  3. Perform the alter table command.

After you have changed the command to address any reported errors, set showplan and noexec to off so that SAP ASE actually performs the work.

All runtime data-dependent errors (for example, errors of numeric overflow, character truncation, and so on) can be identified only when the statement executes. Either change the command to fit the data available, or fix the data values to work with the required target datatypes the statement specifies. To identify these errors, run the command with noexec disabled.