What is Data Definition Language(DDL)?



Author: Suraj
+0 -0

Data Definition Language (DDL) is a subset of SQL (Structured Query Language) that is used to define and manage the database schema. DDL includes a set of commands for creating, altering and deleting database objects such as tables, indexes, views, and procedures.
Some common DDL commands include:
CREATE: used to create new database objects such as tables, views, and indexes.
ALTER: used to modify the structure of existing database objects such as tables and indexes.
DROP: used to delete existing database objects.
TRUNCATE: used to delete all the data from a table but keeps the structure and integrity of the table.
RENAME: used to rename existing database objects.




Submit Your Response