Select to view content in your preferred language

Cannot see a new database attribute added by SQL to feature class in SQL Server GDB

837
2
08-28-2012 09:08 AM
JamesFox1
Frequent Contributor
We have a customer who added a simple date attribute using a SQL command (ALTER TABLE...) to a SQL Server based geodatabase. The column is visible in the SQL or Enterprise Manager interface but does not show up in ArcGIS. Rebooting and re-opening tools does not change the behavior.

SQL Server 2008 R2 and ArcGIS SDE/Desktop 10.1

This is an interesting dilema in that we have other customers who do the same all the with a Oracle 10g R2 geodatabase but their backends are SDE 9.2-9.3 based.

Thanks,

-Jim Fox
0 Kudos
2 Replies
ShannonShields
Esri Contributor
What type of date field did you add? The datetime and datetime2 types are supported in ArcGIS, but the date type is not.

-Shannon
0 Kudos
KimPeter
Esri Contributor
Hi James,

When you added the date field, did you use a date type supported by ArcGIS?  If not, it won't show up in ArcGIS Desktop.

You can check the supported types in the ArcGIS help:
http://resourcesstg.arcgis.com/en/help/main/10.1/index.html#/SQL_Server_data_types_supported_in_ArcG...

-Kim
0 Kudos