CODEWITHSUNDEEP
sql-server-2005ssms
TechnoCore
TechnoCore

Reputation: 1404

SQL Server Management Studio: insert comment in view definition

It is possible to insert comments in views in SQL Server Management Studio (2005)? I talk about the window that you see after you right click on a view in the object explorer and choose Modify.

I tried to insert different kind of comments in the SQL code but it all leads to syntax errors.

Upvotes: 4

Views: 5000

Answers (1)

Blorgbeard
Blorgbeard

Reputation: 103447

This works for me - when I "script as -> create", the comment shows up.

create view [dbo].[v_test] as 
/* this is my view */
select * from Items

Upvotes: 6

Related Questions