How To Use Comments In SQL

In this article, we will learn how to use the Comments in SQL.

Comments can be used to explain sections of SQL statements, and to make it more readable. It can also be used to prevent execution when testing alternative SQL statements.

Single-Line Comments

Single line comments start with two hyphens (- -).

Example

--Returns all Articles.
SELECT * FROM Article;

Multi-Line Comments

Multi-line comments start with /* and end with */.

Example

/*Returns all the columns
in the Article table.*/SELECT * FROM Article;

Also, check How To Use WHILE Loop In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.