Adding NOT NULL fields with Defaults to a featureclass or table

Idea created by pazelt on Aug 27, 2013
    • pazelt
    • Hornbydd
    • rgrichards
    • rfairhur24
    • u40301
    • rchasan
    At the moment, when you want to add a new column to an existing featureclass or table with data you cannot add a NOT NULL column, even if you set a default value.

    If you want to do that you have to copy the fc or table, delete the data in it, add the new column and copy the data from the original table. Than you have to delete the original table and rename the new table.

    Due to the database should allow to add a NOT NULL column with a default value this should be able in ArcGIS Desktop (Catalog), too!