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,

id
name
semester
year

Recommended Recommends

Comments

Contact Us