what is ddl and dml

Question

can you please help me understand from scratch about DDL & DML ...

Answer 1

A good place to start is here. That said, I dont think merely reading that (or any other) article would do. I think you should try out the DDL and the DML statements in the database you are using. Only then you can understand the concepts.

Answer 2

DDL is Data Definition Language : it is used to define data structures.

For example, with SQL, it would be instructions such as create table, alter table, ...

DML is Data Manipulation Language : it is used to manipulate data itself.

For example, with SQL, it would be instructions such as insert, update, delete, ...

Answer 3

DDL = Data Definition Language, any commands that provides structure and other information about your data

DML = Data Manipulation Language, there's only 3 of them, INSERT, UPDATE, DELETE. 4, if you will count SELECT * INTO x_tbl from tbl of MSSQL (ANSI SQL: CREATE TABLE x_tbl AS SELECT * FROM tbl)