Computer Science, asked by grill45, 11 months ago

Difference between DDL and DML commands.​

Answers

Answered by akshay6031
8

Answer:

difference between DDL and DML commands

Explanation:

DDL : DDL (DATA DAFINITION LANGUAGE) is used to specify the database schema database structure. On the other hand

DML : DML (DATA MANIPULATION LANGUAGE) is use to access , modify or retrieve the data from the database

Answered by Potato4Lyf
16

DDL (Data Definition/Description Language):

  • Data definition language is a standard for commands that define different structures in a database.
  • DDL statements create, modify and remove database objects such as tables, indexes and users.
  • Common DDL statements are:
  1. Create (Create)
  2. Alter (Modify)
  3. Drop (Delete)

DML (Data Manipulation Language):

  • Data manipulation language enables users to access and manipulate data in a database.
  • Aim is to provide efficient human interaction with the system.
  • It involves:
  1. Select statement (Retrieval of information)
  2. Insert statement (Insertion of information)
  3. Delete statement (Deletion of information)
  4. Update statement (Modification of information)

Please mark this as brainliest. #BeBrainly

Similar questions