English

How To: Change the column definition of a versioned feature class

Summary

Changing a column definition of a versioned feature class in ArcSDE would have a negative impact on the integrity of spatial database versions.

Procedure

Make all changes to column definitions through the adopted relational database management system (RDBMS), making certain the same changes are made to the "Adds" table.

  1. In order to locate the correct "Adds" table, construct a SQL statement with the RDBMS that reads:

    Code:
    select registration_id from sde.table_registry
    where table_name = '<name>'
    and owner = '<owner>';


  2. Alter the business table and the "Adds" table using:

    Code:
    alter table <name> modify (<column> <column type>;

    Warning:
    This change will have no affect on any existing version.