Data Manipulation Language Functions and How does it work :
DATA DEFINITION LANGUAGE: DATA DEFINITION LANGUAGE (DDL) is a subset of SQL (Structured Query Language) used for defining and managing the structure of a database. DDL provides a set of SQL commands that allow users to define, modify, and manage the various database objects such as tables, views, indexes, constraints, and schemas. CREATE: Used to create new database objects such as tables, views, indexes, constraints, and schemas. ALTER : Used to modify the structure of existing database objects such as tables, views, and schemas DROP: Used to delete existing database objects such as tables, views, indexes, constraints, and schemas. TRUNCATE: Used to remove all data from a table while keeping the structure intact. For example: RENAME: Used to rename existing database objects such as tables, views, indexes, constraints, and schemas. DDL commands are typically executed by users with appropriate privileges, such as database administrators or users with ownership right...