Tamil Nadu Board of Secondary EducationHSC Science Class 12th
Advertisement Remove all ads

SQL Commands and Their Functions

Advertisement Remove all ads

Topics

description

  • DDL Commands
  • Type of Constraints
  1. Unique Constraint
  2. Primary Key Constraint
  3. Default Constraint
  4. Check Constraint
  5. Table Constraint 
  • DML Commands
  1.  INSERT command
  2. Delete Commond
  3. DML Commond 
  4. Update Commond
  • Some Additional DDL Commands
  1. Alter Commands
  2. Truncate command 
  3. Drop Table command
  • DQL COMMAND– SELECT command
  1. DISTINCT Keyword
  2. ALL Keyword
  3. BETWEEN and NOT BETWEEN Keywords
  4. IN Keyword
  5. ORDER BY clause
  6. WHERE clause
  7. GROUP BY clause 
  8. HAVING clause
  • TCL commands
  1. COMMIT command
  2. ROLLBACK command
  3. SAVEPOINT command
If you would like to contribute notes or other learning material, please submit them using the button below.
Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×