In focus

    About DDL

    DDL stand for (Data Definition Language) and it is a database language used to create and modify the structure of database objects in a database including views, schema, tables and indexes, etc. It is also known as Data Description language which is the mainly used for data description which is used in the Data Base Management System. DDL is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP. The DDL have pre-defined syntax for describing data. For example, when we build a new table using SQL syntax by using CREATE command is used table name and column definitions. The DDL can also define the name of each column and the associated data type. Once a table is created then it can be modified using the ALTER command. If the table is no longer needed, the DROP command can be used to delete the table.