Biography, Science, Technology, Health, History Blogs

Database Language Types of Database Language  Data definition language (DDL), Data manipulation language (DML), Data control language (DCL), Transaction control language (TCL), Database Language A DBMS has appropriate languages and interfaces to express database queries and updates. Database languages can be used to read, store and update data in the database. Types of Database Language 1. Data Definition Language DDL stands for Data Definition Language. It is used to define the database structure or pattern. It is used to create schema, tables, indexes, constraints etc in the database. Using DDL statements, you can create the skeleton of the database. Data Definition Language is used to store the information of Meta data such as number of tables and schemas, their names, indexes, columns in each table, constraints, etc. Here are some tasks that come under DDL: Create: It is used to create objects in the database. Alter: It is used to change the structure of the database. Drop: ...