A Data Manipulation Language (DML) is a computer programming language used to add, delete, and modify data in a database. DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. A popular DML is Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database. DML commands are divided into two types: procedural programming and declarative programming.
Some key features of DML include:
- CRUD operations: These are operations to create, read, update, and delete data.
- SQL-data change statements: These modify stored data but not the schema or database objects.
- Syntax: DML commands can have a specific syntax to handle data in that language.
- Built-in functions: There are many built-in functions in SQL Server such as aggregate, conversion, date, mathematical, string, and system.
DML statements allow users to query, edit, add, and remove data stored in database objects. The primary DML commands are SELECT, INSERT, DELETE, and UPDATE. Using DML statements, users can perform powerful actions on the actual data stored in a system. DML SELECT statements are typically written in data models to conduct data analysis or create reports.