Database Administration

Common statements for SQL DDL (Data Definition Language and SQL DML (Data Manipulation Language).

  • SQL DDL CREATE adds a new Database Object for a Database
  • SQL DDL DROP Removes an Existing Database Object
  • SQL DDL ALTER Changes and Existing Database Object
  • SQL DDL USE Switches or Changes to Another Database
  • SQL DDL TRUNCATE Removing Record(s)-Row(s) From a Table and
    Freeing Up Space Used by Those Record(s)-Row(s)
  • SQL DML INSERT Adding New Record(s)-Row(s) to a Table or View
  • SQL DML DELETE Removes Record(s)-Row(s) From a Table or View
  • SQL DML UPDATE Changing Data” in Existing Record(s)-Rows(s)
  • SQL DML MERGE for Inserting, Updating, Deleting
    for Results of Join

 

%d bloggers like this: