Comments in SQL Views

[allochthonous]

Is there any way to get comments to "stick" in a view in SQL Server 2005 (Express)? I can comment when i use "Edit" of course, but I would love it if they would be visible in the view "Design" as well.

PK

 

[RiverGuy]

Don't use the "edit" functionality. Instead, learn how to write views with DDL.

CREATE VIEW v_SomeView AS
--Select something
......

ALTER VIEW v_SomeView AS
--Select something
......

 

[allochthonous]

Is this not the same functionality as when you use "Edit" through the Management Studio GUI?

I can get comments to stick there. I was wondering if there was a way for them to display when you use the "Design" method.

PK

 

[gmmastros]

The "Design" mode for views has several irritating limitations. As such, you should probably limit it's use.

If you continue using the design mode, you will notice that there is a "SQL Comment" section in the properties window. If you do not see the properties window, you can show it by pressing F4 or click View -> Properties Window.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[allochthonous]

This must be one of those "annoying limitations". This comment section via Properties is a but clumsy, but might suffice for now. I will try to start using Edit instead of Design.