DATA DEFINITION LANGUAGE

 A. DATA DEFINITION LANGUAGE

  • Data Definition Language (DDL) is a part of SQL that is used to define and manage database structures. It includes commands for creating, altering, and dropping database objects such as tables, schemas, and indexes.





B. INTERACTIVE DATA MANIPULATION LANGUAGE

  • iDML includes commands for querying data, updating data, inserting new records, and deleting existing records. Here are some examples of iDML commands




C. EMBEDDED DATA MANIPULATION LANGUAGE

eDML is typically used in applications that require frequent or complex data manipulation operations. By embedding the database commands within the application code, the application can perform database operations more efficiently and with greater control.

Comments