Table's fully qualified name - SCHEMA?

RyanKelso — Wed, 31 Jan 2018 00:10:53 GMT

When looking at the fully qualified name of an sde geodatabase table in ArcMap or ArcCatalog, it is always displayed as DatabaseName.SCHEMA.TableName. At least it is with my setup: SQL Server 2014 and ArcGIS 10.4.1. Is there any way to make it so SCHEMA is not always displayed in all-caps? This is basically a non-issue, it's just annoying to look at, so it would be nifty if there was a way to change it. Thanks.

Re: Table's fully qualified name - SCHEMA?

JonathanFarmer_oldaccount — Thu, 12 Apr 2018 20:47:15 GMT

Hi Ryan,

I noticed that you had not gotten a response to this question so I wanted to go ahead and answer this here in case you were still wondering.

You are correct, for a SQL Server enterprise geodatabase we display the feature in a "databasename.SCHEMANAME.featurename" format. We do not offer a way to change the schema name to a lower case format. One thing you'll notice is that views created in the database have a lower case schema name but feature classes, feature datasets, etc. are all uppercase. This is by design.

Hope that helps. Let me know if I can answer anything else for you.

Jonathan

topic Table's fully qualified name - SCHEMA? in Geodatabase Questions

Table's fully qualified name - SCHEMA?

Re: Table's fully qualified name - SCHEMA?