Select to view content in your preferred language

Enterprise geodatabase Schema case (upper/lower)!

1349
2
04-04-2018 04:30 AM
Muqit_Zoarder
Frequent Contributor

Dear forum members, I have simple but big problem regarding schema case in sql server enterprise gdb. If I create any table or feature class in sql server through ArcGIS then the schema name creates as uppercase letter by default and the table name is as it is. But in sql server table list (directly in sql server) I find all the schema name as lowercase (for example: dbo.TABLEX) but the table name in opposit case. If I again search through arcgis database connection then I see all the tables and feature class schema is uppercase ( for excample: DBO.tablex). This makes a big issue when I connect my db into fme and make some download data task.

My question is: is there any solution thus I can create the schema in lowercase from arcgis?

With kind Regards

Muqit Zoarder

2 Replies
KimGarbade
Frequent Contributor

Too bad you didn't get a reply.  This is my problem also in 2023.

ANH
by
Occasional Contributor

This is the same issue we are facing. This is the only post that I can find that mentions this issue. This is occurring when copying data to a v10.9.1 Enterprise GeoDatabase.

0 Kudos