Hi

When creating/editing my SQL Views in visual studio 2008 I find it a bit difficult because you dont get the same support you do when creating stored procedures or functions. For example you don't get the different colours identifying data types etc..

Why is this? And is there a way I can change it?

I'm quite new to SQL Views so theres probably a valid reason I've missed.

Thanks!

As far as I know you can't change it, because you're using the Query and View Designer when working with a View, and not the SQL Editor which is used for Stored procedures.

Thanks for your reply. Do you know why the Query and View Designer is used on Views and not the SQL Editor? I'm just trying to understand why this is seen as a more beneficial method.

I don't know why, but I'm guessing that the Query and View Designer makes it easy for most people to select the tables and columns they want to see, and that's really all they do with it. I tend to agree, even if the color coding is missing. Mind you, you could have a color coded SQL pane in the Query and View Designer, although it wouldn't be quite as helpful there as it is when writing a stored procedure IMHO. I guess that is a wish for VS 2010, eh? :-)

Haha definetely, thanks for your help