What is the full form of DDL?

Full form of DDL: Here, we are going to learn what does DDL stands for? DDL – which is an abbreviation of "Data Definition Language" in Computer Acronyms/Abbreviations, etc.
Submitted by Anushree Goswami, on November 22, 2020

DDL: Data Definition Language

DDL is an abbreviation of "Data Definition Language", which is also known as a data description language. DDL is a syntax intended to be used in the process of creation and modification of database objects in SQL, comprise tables, indexes, and users.

Examples of DDL syntax comprise CREATE, ALTER, and DROP.

DDL History

  • First time the name of the Data Definition Language and its model was brought in association with the Codasyl database model.
  • In a while, it was used to make mention of a subset of Structured Query Language (SQL) in favor of declaring tables, columns, data types and constraints.

CREATE statement

  • The use of the CREATE statement command is take place with the purpose to set up a new database, table, index, or kept in reserve course of action.
  • In SQL, the CREATE statement operates by creating an elemental module in a relational database management system (RDBMS).
  • The general usage of CREATE statement is:
    Syntax: CREATE TABLE [table name] ([column definitions]) [table parameters]

DROP statement

  • The use of the DROP statement command is take place with the purpose to wipe out an established database, table, index, or view.
  • In SQL, a DROP statement operates by taking out an elemental module from a relational database management system (RDBMS).
  • The general usage of DROP statement is:
    Syntax: DROP objecttype objectname

ALTER statement

  • The use of the ALTER statement command is take place with the purpose to make changes for improvisation in an established database object.
  • In SQL, an ALTER statement operates by altering and modifying the attributes of an object contained by a relational database management system (RDBMS).
  • The general usage of ALTER statement is:
    Syntax: ALTER objecttype objectname parameters

Reference: Data definition language


Algo tagged in: Dictionary – 'C'






Comments and Discussions

Ad: Are you a blogger? Join our Blogging forum.





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates


© https://www.includehelp.com some rights reserved.