Describe Data Definition Language (DDL). DBMS

Data Definition Language (DDL): The specific language used to express the database schema by a set definitions is called Data Definition Language (DDL). The DDL is also used to specify additional properties of the data. Another special type of DDL, called the Data Storage and Definition Language, is used to specify storage and data access methods.

Explanation with Example: Supposing that we are in need to create a table which is having these attributes id, name, semester, year where the name of the table will be uits. To define this table along with its attributes we will use the following SQL statements,

Describe Data Definition Language

create table uits
(id integer,
name char(20), 
semester integer,
year integer);

These lines of codes will create the following table,


Author: Tanmay Chakrabarty

Tanmay Chakrabarty is a former CSE student, currently working as a Senior Software Engineer with 5+ years of experience in the field of Web Application development in PHP+MySQL platform with strong skills in Javascript, JQuery, JQuery UI and CSS. He tries to write notes every week but fails due to heavy loads of duty.

Recommended Recommends


Contact Us