SQL (Structured Query Language) categories in three languages

1. Data Definition Language (DDL)

Which is also known for Data Description Language used for specifying the database schema, like as creating, modifying, and destroying tables, views, indices, and stored procedures

• A CREATE statement (example of Create Table)
• A DROP statement (example of Drop Table)
• An ALTER statement (example of ALTER TABLE)

• Referential integrity statements (Example of implementing as a primary key and foreign key tags in some columns of the tables.)

2. Data Manipulation Language (DML)

This is used to manipulate or query data using insert into, delete from, update, and select statements.

3. Data control language (DCL)

This is used to control access using Grant and Revoke Statements for database access and data stored in a database.

Posted on February 06, 2014 by Amit Pandya in SQL