What is DDL and DML
Most database management systems (DBMS) have Data Definition Languages (DML) and Data Manipulation Languages (DML). When it comes to a Relational DBMS (RDBMS), DDL commands such as create, alter or drop table; and DML commands such as select, insert, update, and delete are all SQL.
You may notice some industry analysts or architects using the term DBMS, not database. Many don’t care, but technically a database is just the data store. The DDL and DML is the compute. Together they are the DBMS. So why don’t we talk about a data warehouse management system (DWMS)? I don’t know, but I’m grateful.