topic Re: Cannot see a new database attribute added by SQL to feature class in SQL Server in Data Management Questions

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

JamesFox1 — Tue, 28 Aug 2012 16:08:52 GMT

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

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

ShannonShields — Wed, 29 Aug 2012 20:15:49 GMT

What type of date field did you add? The datetime and datetime2 types are supported in ArcGIS, but the date type is not.

-Shannon

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

KimPeter — Wed, 29 Aug 2012 22:01:12 GMT

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_ArcGIS/002q00000068000000/

-Kim