Enterprise geodatabase Schema case (upper/lower)!

1006
1
04-04-2018 04:30 AM
Muqit_Zoarder
Occasional 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

0 Kudos
1 Reply
KimGarbade
Occasional Contributor III

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

0 Kudos