What does DDL stand for? List the SQL DDL statements.
-
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.