Add a Comment to a Query

You can document a view, user-defined function, or single statement stored procedure by adding a comment to it. You can enter a comment in a property page.

1. In the Database window, click Queries   under Objects, click the view, user-defined function, or single statement stored procedure you want to open, and then click Design on the database window toolbar.
2. Right-click in the Query Designer, then select Properties from the shortcut menu.
3. Enter the comment in the SQL Comment field.

Notes

• You should avoid entering the two-character strings "/*" and "*/" within your comments.
• If you change the type of query (for example, from a SELECT query to an UPDATE query), the queryÆs comment is deleted.