List few commands of DDL DML and DCL

Here we have complete list of database,dml, dcl, ddl commands .

Data Definition Language (DDL) commands:

• CREATE to create a new table or database.
  
• ALTER for alteration.
  
• Truncate to delete data from the table.
  
• DROP to drop a table.
  
• RENAME to rename a table.
  

Data Manipulation Language (DML) commands:

• INSERT to insert a new row.
  
• UPDATE to update an existing row.
  
• DELETE to delete a row.
  
• MERGE for merging two rows or two tables.
  
• Data Control Language (DCL) commands:
  
• COMMIT to permanently save.
  
• ROLLBACK to undo the change.
  
• SAVEPOINT to save temporarily.
  

Examples of DDL commands:

• CREATE – is used to create the database or its objects (like table, index, function, views, store procedure and triggers).
  
• DROP – is used to delete objects from the database.
  
• ALTER-is used to alter the structure of the database.