affiliate marketing Interview Qns: DDL is Data Definition Language statements. Some examples:

Monday, October 25, 2010

DDL is Data Definition Language statements. 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
  • COMMENT - add comments to the data dictionary
  • GRANT - gives user's access privileges to database
  • REVOKE - withdraw access privileges given with the GRANT command

No comments:

Post a Comment