SQL Statements


Introduction

SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. This article describes different types of statements available in SQL.




Getting Started

SQL statements in SQL are broadly classified into three. They are

Data Definition Language(DDL)

Data Definition Language is a standard for commands that is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

Data Manipulation Language(DML)

Data Manipulation Language is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. Select statement is considered as a limited version of DML, since it can't change data in the database. But it can perform operations on data retrieved from DBMS, before the results are returned to the calling function.





Data Control Language(DCL)

Data Control Language is used to provide authorization to user for accessing data from database like, it sets privileges for creating database object like table creations, modification, delete data from table etc.

Summary

Hope you have got about difference SQL Statements and their use.

Thanks
Kailash Chandra Behera


No comments:

Post a Comment