DDL Commands
Week 2: Articles
Data Definition Language (DDL) Commands
Learning Outcomes
- Learn how to create, modify, and remove structures, like tables.
- Learn how the various DDL statements work.
Lesson Materials
CREATEStatement- The
CREATEstatement lets you create new objects in a database. TheCREATEstatement writes the information for new objects to the data dictionary. TheCREATEstatement also can leverage default storage clauses that govern the organization of the object inside the physical space of database files. ALTERStatement- The
ALTERstatement lets you modify the structure of existing objects in a database. DROPStatement- The
DROPstatement lets you remove the structure of existing objects from the database provided there are no dependent object types. RENAMEStatement- The
RENAMEstatement lets you rename a structure in the database. You can only rename objects with names not already found in the schema or database. TRUNCATEStatement- The
TRUNCATEstatement lets you remove the data from a table without writing the changes to a logging file. COMMENTStatement- The
COMMENTstatement lets you add text comments to a table or columns in a table.
