Friday, 12 September 2014

DDL commands

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
  • CREATE - to create objects in the database
  • ALTER - alters the structure of the database
  • DROP - delete objects from the database
  • TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
  • RENAME - rename an object

Create


Alter


Drop



Truncate




Rename



No comments:

Post a Comment