Discussion RoomCategory: Database&SQLWhat is DDL and what are some commands of DDL?
Mohan asked 4 years ago

DDL stand for Data Definition Language. It is managing properties and attributes of database.DDL commands are used to define the structure that holds the dataThese commands are auto-committed i.e. changes done by the DDL commands on the database are saved permanently.
Some DDL commands are:

  • CREATE to create a new table or database.
  • ALTER for alteration.
  • Truncate to delete data from the table.
  • DROP to drop a table.
  • RENAME to rename a table.