what is ddl and dml

In the context of databases, DDL stands for Data Definition Language, while DML stands for Data Manipulation Language. DDL is used to create and modify database objects like tables, indexes, views, and constraints, and it is used to define the structure of a database. On the other hand, DML is used to manipulate the data within the database, and it is used to perform operations on the data within those database objects. Examples of DDL commands include CREATE, ALTER, and DROP, while examples of DML commands include INSERT, UPDATE, and DELETE. DDL statements are typically executed less frequently than DML statements, and they are typically executed by database administrators, while DML statements are frequently executed to manipulate and query data, and they are typically executed by application developers or end-users.