Home » , » Data Definition Language (DDL) statements?

Data Definition Language (DDL) statements?

01:54
  • Data Definition Language (DDL) statements  Allow you to define the data structures, such as tables, that make up a database. There are five basic types of DDL statements:
    • CREATE  Allows you to create a database structure. For example, CREATE TABLE is used to create a table; another example is CREATE USER, which is used to create a database user.
    • ALTER  Allows you to modify a database structure. For example, ALTER TABLE is used to modify a table.
    • DROP  Allows you to remove a database structure. For example, DROP TABLE is used to remove a table.
    • RENAME  Allows you to change the name of a table.
    • TRUNCATE  Allows you to delete the entire contents of a table.
Categories: ,