SQL Commands - DDL : DML : DCL : DQL : TCL

 SQL Commands :

sql commands can be classified into groups based in their nature -

SQL Commands - DDL, DML, DCL, DQL, TCL

1.DDL(DATA DEFINITION LANGUAGE)

a.Create
b.Alter
c.Drop

2.DML(DATA MANIPULATION LANGUAGE)

a.Insert
b.update
c.delete

3.DCL(DATA CONTROL LANGUAGE)

a.Grant
b.Revoke

4.DQL(DATA QUERY LANGUAGE)

a.Select

5.TCL( TRANSACTIONAL CONTROL LANGUAGE)

a.Commit
b.Rollback
c.Save Transaction’