DDL | DML |
---|---|
Allow task to define the database structure | Allow task to manage data stored in database |
Exp- CREATE, ALTER, DROP | Exp- INSERT, DELETE, SELECT |
DDL statement operate on entire table | DML statement operate on rows |
TCL statement can not be used with DDL | TCL statement can be used with DML |