AnsweredAssumed Answered

Values null in SQL but not in ArcCatalog

Question asked by Mmitchell_DU on Jan 4, 2018
Latest reply on Jan 5, 2018 by Mmitchell_DU

If I view a table in ArcCatalog the Name column has values that are not null.  There is no domain associated with this column.

If I query the same table in SQL the same values display as null.

 

I've noticed this with multiple tables and the only thing that seems similar between them is that the null value columns come after the Shape column.  Is the enterprise geodatabase somehow storing values that have been added post import differently?

 

The SQL query is simply

SELECT *
FROM gis.dbo.REGIONS

Every column after shape is null.

Outcomes