What is DDL in SQL?

Question

Can anyone explain the DDL commands in SQL?

Answer 1

DDL stands for Data Definition Language is a type of SQL commands that deals with database schemas and descriptions of how the data have to reside in the database.

• CREATE - to create a database, table, index, views, store procedure, function, or triggers
• ALTER – to change or modify the structure of the existing database
• DROP – to delete not only the data stored in the table but also the table from the database
• TRUNCATE – to delete all records from a table, even the spaces allocated for the records but not the table itself.
• RENAME – to rename the objects of the database like table, columns, etc.

To learn DDL commands in SQL, you can register for this SQL online course by Intellipaat.