The Types of SQLs

 What is a Data Definition Language?


     Data Definition Language (or DDL) includes those SQL statements that create and drop locations, databases and database objects such as tables and indexes, it also includes statements to alter database objects and impose integrity constraints on tables.

Interactive Data Manipulation Language

     What is interactive Data Manipulation Language? It is simply a data manipulation language allows users to access and retrieve database contents in both interactive and embedded modes, now that's interesting!
     It also includes constructs that allow retrieval and manipulation of database content.

Embedded Data Manipulation Language

Now what about embedded data manipulation language? Well Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language.




Comments

Popular posts from this blog

INTRODUCTION TO JSON

Introduction to Computing Blog

Activity Quiz (BLOGPOST#3)