Data Definition Language-DDL

By | November 7, 2013

These are used to define database structure or

schema

Examles as below

1.CREATE- create objects in the database
2.ALTER- alters the structure of the database
3.DROP-delete the objects from the database
4.TRUNCATE-remove all the records from the database  including spaces allocated for the records are removed.
5.COMMENT-add comments to the data dictionary
6.RENAME-rename an object.