AnsweredAssumed Answered

views in SQL 2012

Question asked by kwallis@cityofnapa.org on Feb 26, 2016
Latest reply on Feb 27, 2016 by asengupta-esristaff

Hi

I am new to SQL2012... upgraded from SQL08. 
Two questions -

In SQL08 we did views for certain layers, but now that all my data is in the Local Gov Info Model which has  
  several feature datasets, having the view appear at the very bottom of my data layers in ArcCatalog is confusing
  for my departments. Would like have my views placed with the feature dataset. That way the planning dpt. can see the
  views that apply to their data inside the LandusePlanning feature dataset etc.
  So at 10.3 and above can views that join spatial data to tables live inside a feature dataset?

Second question - When I look at the data in my SQL Server management studio window, I see that every
layer in my database has a corresponding view  in the SQL database called LAYERNAME_EVW
What are these? When I look at them in design view they like preconfigured views that I just need to update?

Thank you

Katy

Outcomes