Difference between DML statements and DDL statements

[Prashobh Mallu]

Hi Friends,

I need your help to solve my confusion about the DML ans DDL statements of the SQL. I don't know what is the exact difference between DML ans DDL statements. The commands like select, insert, update comes in which category , i.e in DML statements or DDL statements? please let me know some differences between the DML statements and DDL statements. I would greatly appreciate your any help over this.

[opaper]

• DDL statements (Data Definition Language) are basically used to define the structure of the database or schema of the database. DDL staements are used to develop a structure to the table.
• DML statements (Data Manipulation Language) are basically used to manage the data of the schema object. DML statements are used to used to perform the updations to the data

[MindSpace]

DDL statement defines the database structure. Following are some DDL commands which are available in the SQL:

1. ALTER :It is used to alters the database structure.
2. COMMENT : It is used to add comments in the data dictionary.
3. DROP : It is used to delete database objects.
4. CREATE : It is used to create database objects.

[Modifier]

Hi,

DDL is the abbreviation of the Data Definition Language. These statements are used to define the schema as well as the database structure. DML is the abbreviation of the Data Manipulation Language. These statements are used for the management of the schema objects. The examples of the DDL statements are :ALTER, CREATE, DROP , RENAME, TRUNCATE , COMMENT etc. While the examples of DML statements are DELETE, SELECT, UPDATE , INSERT etc..

[Praetor]

If you want to be aware about the DML statements then please refer following it's examples:

• update statements: Used to updates existing data .
• delete statements: Used to deletes records from a table
• lock table statements: Used for control concurrency
• select statements: retrieve data from the a database
• insert statements: Used to insert data into a table

[Katty]

Hello friend,

The DML statements are entirely different as compare to the DDL statements. DML statement is used for schema while the DDL statement is used for schema structure. 'update', 'delete', 'insert' are some example of the Data Manipulation Language statements while 'drop', 'create', 'alter' are the examples of Data Definition Language statements. Basically the Data Manipulation Language statements are used to access the data from the data structure which is created by the Data Definition Language statements