Last updated on August 29th, 2020 at 09:57 am
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,
create table uits
These lines of codes will create the following table,