ArcCatalog New>View Creates View as Lower Case dbo

435
0
05-17-2017 05:39 AM
WalterDziuba1
New Contributor III

I often create views using ArcCatalog with New>View and add the view to my database. The view is created with the following naming convention:

TestDeploy.dbo.SpecialView

I then add the view to my .mxd and continue on with my project.

During the publishing process, the analyze step flags an error with this view, stating that the view is not recognized and is not registered to the database. I then use the tool "Feature Class to Feature Class" into another temporary .gdb

and then copy the view back with the same command. Unfortunately, this step alters the view into a table and does not retain it's view parameters

Then, the newly created table will have the following naming convention:

TestDeploy.DBO.SpecialView

Why does the initial New>View create the view with lower case "dbo"?

And why does the transferred table now become "DBO"?

Is there an issue with my database connection that it creates a dbo.view and not a DBO.view?

Walter

0 Kudos
0 Replies