SQL Server Management Studio: Insert a comment in a definition definition

Can I add comments to views in SQL Server Management Studio (2005)? I am talking about the window that you see after right-clicking on the view in the object explorer and selecting "Modify".

I tried to insert different comments into the SQL code, but all this leads to syntax errors.

+4
source share
1 answer

This works for me - when I "script as β†’ create", a comment appears.

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

Source: https://habr.com/ru/post/1346190/


All Articles