I used TOAD to change a feature class column from non-nullable to nullable. And I added a trigger to populate a default value. ArcCatalog still shows the column as non-nullable. So does the ArcGIS Server Services Directory for a feature service published on this layer. And they seem unaware of the trigger - So I still can't insert features with a null value for this column.
thanks for the feedback. note to self, use the SDE command line.
SDETABLE reflects the same info as TOAD. ArcGIS still says different.
I used SDETABLE -o alter_column to make this nullability change to a second feature class. That didn't work any better. As before, the change isn't visible to ArcGIS - ArcCatalog still shows it as not-nullable.
Is there a way to make this sort of change to a feature class such that ArcGIS sees the change, or some way to cause the GDB system tables, such as COLUMN_REGISTRY.OBJECT_FLAGS to refresh or repair?
The alternative seems to be to add a new column, copy over the data from the old column. Seems heavy-handed.