Introducing SQL
SQL Statements DATA DEFINITION LANGUAGE Data definition language is also known as data description language as it describes the fields and records in a database table and define changes in the database schema. DDL is a subset of SQL or Structured Query Language which implements database modifications. DDL commands are used for altering the database structure such as creating new tables or objects along with all their attributes (data type, table name, etc.). DATA MANIPULATION LANGUAGE Data Manipulation Language or DML is a subset of operations used to insert, delete, and update data in a database. It is a sublanguage of SQL as it comprises some of the operators in the language. Selecting read-only data is closely related and is sometimes also considered a component of a DML, as some users can perform both read and write selection. EMBEDDED DATA MANIPULATION LANGUAGE Also known as Embedded SQL is a method of combining the computing ...