Tutorialspoint.dev

SQL | Comments

As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet.

Comments can be written in the following three formats:

  1. Single line comments.
  2. Multi line comments
  3. In line comments

  • Single line comments: Comments starting and ending in a single line are considered as single line comments.
    Line starting with ‘–‘ is a comment and will not be executed.
    Syntax:

    --single line comment
    --another comment
    SELECT * FROM Customers; 
    
  • Multi line comments: Comments starting in one line and ending in different line are considered as multi line comments. Line starting with ‘/*’ is considered as starting point of comment and are terminated when ‘*/’ is encountered.
    Syntax:



    /* multi line comment
    another comment */
    SELECT * FROM Customers; 
    

  • In line comments: In line comments are an extension of multi line comments, comments can be stated in between the statements and are enclosed in between ‘/*’ and ‘*/’.
    Syntax:

    SELECT * FROM /* Customers; */ 
    

    More examples:

    Multi line comment ->
    /* SELECT * FROM Students;
    SELECT * FROM STUDENT_DETAILS;
    SELECT * FROM Orders; */
    SELECT * FROM Articles; 
    
    In line comment ->
    SELECT * FROM Students;
    SELECT * FROM /* STUDENT_DETAILS;
    SELECT * FROM Orders;
    SELECT * FROM */ Articles; 
    

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.



This article is attributed to GeeksforGeeks.org

You Might Also Like

leave a comment

code

0 Comments

load comments

Subscribe to Our Newsletter