Difference between DDL and DML commands.
Answers
Answered by
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
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:
- Create (Create)
- Alter (Modify)
- 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:
- Select statement (Retrieval of information)
- Insert statement (Insertion of information)
- Delete statement (Deletion of information)
- Update statement (Modification of information)
Please mark this as brainliest. #BeBrainly
Similar questions