DDL - Data Definition Language

DDL - Data Definition Language, DDL - Data Definition Language, DDL - Data Definition Language, DDL - Data Definition Language,

DDL - Data Definition Language

A database schema is specified by a set of definitions expressed by a special language called data-definition language DDL. The result of compilation of DDL statement is a set of tables that is stored in a special file called data dictionary. A data dictionary is a file that contains metadata that is data about data.
DDL is a special language, which supports the definition or declaration of database objects, i.e. it is used to specify the data in the database. (It allows users to define the structure of data in the database. This language is not a procedure language. DDL includes statements for creating, manipulating, altering and deleting the tables and views. Some of data definition commands are,
Create Table, Create View, Alter Table, Drop Table 
Create Table student(
roll int,
address varchar(100),
name varchar(100), phone int
)

You May Also Like...