DDL Data definition Language

Used to define databases, structure of the the schemas.

In other words DDL refers to a subset of SQL statements that change the structure of the database schema in some way.

What can you DDL do ?

We can Create = we can w=create objects such as databases or tables , for columns we need to alter

Alter = We can also manipulate objects such as rows databases , but again for columns we would need to alter the table first .

Drop = Delete / remove the tables , rows .

Truncate = this is useful if we want to empty everything inside the tables

Rename = Able to rename tables , columns. However this does not applies for a data base .

Lastly , We can also comment , and leave helpful feedback that may help us while writing code.

Leave a comment