How to modify DimNaturalized View

Nov 27, 2012 at 12:35 PM

Hi,

is there a good way how to modify the view created from the parent/child naturalizer?

I would like to add new columns to the view and i don't want to create the view from the scratch.

When i open the View in Management Studion in Design Mode i get the error message : "Unable to parse query text"

Thanks for help
Arian

Coordinator
Nov 27, 2012 at 2:20 PM

I get the same error when I right click on the view and choose Design in Management Studio. Despite the error, the window comes up. I think the error just means that the view is too complex or uses language constructs it can't visually show in the diagram.

What I do is right click on the view and choose Script View As... Alter To... New Query Editor Window then modify it from there.

Nov 27, 2012 at 3:20 PM

Uuhh that was easy :) Many thanks!!