Question

What is the purpose of DDL Language?

Answer 1

DDL stands for Data definition language. It is the subset of a database that defines the data structure of the database when the database is created. For example, we can use the DDL commands to add, remove, or modify tables. It consists of the following commands: CREATE, ALTER and DELETE database objects such as schema, tables, indexes, view, sequence, etc.

Example

CREATE TABLE Students  

(  

Roll_no INT,  

Name VARCHAR(45),  

Branch VARCHAR(30),  

);