Adding Comments

Go Up to The Procedure Body

Stored procedure code should be commented to aid debugging and application development. Comments are especially important in stored procedures since they are global to the database and can be used by many different application developers.

Comments in stored procedure definitions are exactly like comments in standard C code, and use the following syntax:

/* comment_text */

<comment_text> can be any number of lines of text. A comment can appear on the same line as code. For example:

x = 42; /* Initialize value of x. */