|
|
Difference between DDL and DML?
Similar entries
- Difference between ADO and ADO.NET
- Difference between Form submission methods GET and POST
- Clear your private data before you leave
- mutiple language support- auto translation of web page help
- Difference between Full HD TV and HD Ready TV
- What is the difference between IPO And FPO
- Difference between RTO and RPO in terms of backup and recovery
- Networking terms:Protocol,Services,PDU and SDU
- How to enable/disable USB devices
- Difference between do follow and no follow link
SQL staements can be categorized as DDL or DML statements.
Data Definition Language(DDL)-DDL statements are used to create or alter any database object like table.These statement deals with schema.
DDL statements
CREATE( Creating A database Object),like Create Table
ALTER ( Altering Structure of any object)-Alter Table
Alter Table ...ADD Constraint
DROP(Deleteing any object from database)-Drop Table
Alter Table ...drop Constraint
Grant and Revoke -granting and revoking access rights
Data Manipulation Language (DML)- As its name implies it is used to manipulate data stored in tables. DML statments are
Select,Update,Delete and Insert