What does DDL stand for? List the SQL DDL statements.

  1. What does DDL stand for? List the SQL DDL statements.

DDL stands for Data Definition Language which is used for creating tables relationships and other database structures (Kroenke & Auer). DDL is a set of commands that can manupulate tables, indexes and other properties in a database. Following are some of DDL statements that are used by database designers and programers.

Create Table: This command is used to create a table with different constraints like row and columns.

Alter Table: This command is used to alter certain data in a table e.g. change user properties.

Drop Table: This DDL statement is used to delete a table from the database.

Truncate Table: This command is used to remove all the records contained in a certain database table.

Rename: This command can be used to change the name of a database object.