Comments

Comments are used to attach explanatory text to SQL statements or statement blocks. The database server does not execute comments.

The following comment indicators are supported in SQL Anywhere:

-- (Double hyphen) The database server ignores any remaining characters on the line. This is the SQL/2008 comment indicator.
You can add and remove this comment indicator by selecting text and pressing Ctrl+Minus Sign in Interactive SQL or on the SQL tab of the Procedures & Functions window of Sybase Central.

The SQL comment indicator is added to the beginning of each line of the selected text. If no text is selected, the comment indicator is added to the beginning of the current line.
// (Double slash) The double slash has the same meaning as the double hyphen.
You can add and remove this comment indicator by selecting text and pressing Ctrl+Forward Slash in Interactive SQL or on the SQL tab of the Procedures & Functions window of Sybase Central.

The SQL comment indicator is added to the beginning of each line of the selected text. If no text is selected, the comment indicator is added to the beginning of the current line.
/* ... */ (Slash-asterisk) Any characters between the two comment markers are ignored. The two comment markers can be on the same or different lines. Comments indicated in this style can be nested, but nested comments must be balanced. Any comments made inside the comment block must not contain single instances of the starting comment marker. This style of commenting is also called C-style comments.

Examples

The following example illustrates the use of double-hyphen comments:

CREATE FUNCTION fullname ( firstname CHAR(30),
         lastname CHAR(30))
RETURNS CHAR(61)
-- fullname concatenates the firstname and lastname
-- arguments with a single space between.
BEGIN
   DECLARE name CHAR(61);
   SET name = firstname || ' ' || lastname;
   RETURN ( name );
END;

The following example illustrates the use of C-style comments:

/* Lists the names and employee IDs of employees
   who work in the sales department. */
CREATE VIEW SalesEmployees AS
   SELECT EmployeeID, Surname, GivenName
   FROM GROUPO.Employees
   WHERE DepartmentID = 200;

Standards and compatibility

SQL/2008 The use of double-minus signs for a comment is a core feature of the ANSI SQL/2008 standard. The use of C-style, bracketed comments (/* ... */) is SQL language feature T351 of the SQL/2008 standard. Double-slash comments (//) are supported as a vendor extension.

Comments

Examples

Standards and compatibility

See also