What are the difference between DDL and DML?

-

 



What are the difference between DDL and DML?

DDL

DML

1-DDL stands for data definition language.

2-DDL sub-language is used to work with   header of the table.

3-DDL sub language contains some commands like create,alter,truncate and drop.

1-DML stands for data manipulation language.

2-DML sub-language is used to manipulate the data base object.

3-DML sub language contain some commands like Insert, update and delete.

Comments

Post a Comment

Popular posts from this blog

What is DBMS and RDBMS?

-
Image
  What is DBMS and RDBMS? Ans- DBMS  stands for Database Management System, and RDBMS  is the acronym for the Relational Database Management system. In DBMS, the data is stored as a file, whereas in RDBMS, data is stored in the form of tables
Read more

what is the role of SQL in DBMS?

-
Image
  what is the role of SQL in DBMS? Ans-  SQL stands for Structured Query Language. It is used for  storing and managing data in relational database management system (RDMS) . It is a standard language for Relational Database System. It enables a user to create, read, update and delete relational databases and tables.
Read more