DATA DEFINITION LANGUAGE

 DATA DEFINITION LANGUAGE


        It is a data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas.





Many data description languages use a declarative syntax to define columns and data types. Structured Query Language (SQL), however, uses a collection of imperative verbs whose effect is to modify the schema of the database by adding, changing, or deleting definitions of tables or other elements. These statements can be freely mixed with other SQL statements, making the DDL not a separate language.


Comments

Post a Comment

Popular posts from this blog

XML, JSON, and AJAX

Image
  Extensible Markup Language  (XML) - It l ets you define and store data in a shareable manner . XML supports information exchange between computer systems such as websites, databases, and third-party applications. JSON -  is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays. It is a commonly used data format with diverse uses in electronic data interchange, including that of web applications with servers. AJAX -  It is a set of web development techniques that uses various web technologies on the client-side to create asynchronous web applications. With Ajax, web applications can send and retrieve data from a server asynchronously without interfering with the display and behavior of the existing page.
Read more

INTERACTIVE DATA MANIPULATION LANGUAGE

Image
 INTERACTIVE DATA MANIPULATION LANGUAGE         It is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Most SQL database implementations extend their SQL capabilities by providing  imperative , i.e. procedural languages. Examples of these are  Oracle 's  PL/SQL  and  IBM Db2 's  SQL_PL . Data manipulation languages tend to have many different flavors and capabilities between database vendors. There have been a number of standards established for SQL by  ANSI , [2]  but vendors still provide their own extensions to the standard while not implementing the entire standard. Data manipulation languages are divided into two types,  procedural programming  and  declarative programming . Data manipulation langua...
Read more

EMBEDDED DATA MANIPULATION LANGUAGE

Image
  EMBEDDED DATA MANIPULATION LANGUAGE       It consists of SQL statements used to retrieve, insert, update and delete records from database tables. DML statements are the only statements that can be rolled back or recovered. Deletes specified rows from a table. Also has a special format (DELETE WHERE CURRENT OF) for embedded SQL.       A popular data manipulation language is Structured Query Language or SQL, used to retrieve and manipulate data in a relational database. With SQL, you can perform operations on the database and also use it to create a database. SQL uses specific commands like Create, Drop, Insert, etc., to carry out the required tasks.
Read more