What are DDL and DML?

by

SQL command can be divided into three subgroups, DDL, DML and DCL

The following is adapted from here MySQL What is DDL, DML and DCL?:

DDL

DDL is short name of Data Definition Language, which deals with
database schemas and descriptions, of how the data should reside in
the database.

  • CREATE – to create database and its objects like (table, index, views, store procedure, function and triggers).
  • ALTER – alters the structure of the existing database.
  • DROP – delete objects from the database.
  • TRUNCATE – remove all records from a table; also, all spaces allocated for the records are removed.
  • COMMENT – add comments to the data dictionary.
  • RENAME – rename an object.

DML

DML is short name of Data Manipulation Language which deals with data
manipulation, and includes most common SQL statements such SELECT,
INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve,
delete and update data in database.

  • SELECT – retrieve data from one or more tables.
  • INSERT – insert data into a table.
  • UPDATE – updates existing data within a table.
  • DELETE – delete all records from a table.
  • MERGE – UPSERT operation (insert or update)
  • CALL – call a PL/SQL or Java subprogram.
  • EXPLAIN PLAN – interpretation of the data access path.
  • LOCK TABLE – concurrency control.

DCL

DCL is short name of Data Control Language which includes commands
such as GRANT, and mostly concerned with rights, permissions and other
controls of the database system.

  • GRANT – allow users access privileges to database.
  • REVOKE – withdraw users access privileges given by using the GRANT command.

TCL

TCL is short name of Transaction Control Language which deals with
transaction within a database.

  • COMMIT – commits a transaction.
  • ROLLBACK – rollback a transaction in case of any error occurs.
  • SAVEPOINT – a point inside a transaction that allows rollback state to what it was at the time of the savepoint.
  • SET TRANSACTION – specify characteristics for the transaction.

More Related Contents:

  1. Safely rename tables using serial primary key columns
  2. Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?
  3. Delete column from SQLite table
  4. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  5. Postgres manually alter sequence
  6. How do I add a foreign key to an existing SQLite table?
  7. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  8. DROP FUNCTION without knowing the number/type of parameters?
  9. PostgreSQL create table if not exists
  10. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  11. Drop column from SQLite table
  12. ALTER TABLE without locking the table?
  13. How to delete duplicate rows in SQL Server?
  14. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  15. Is SQL syntax case sensitive?
  16. Limit on the WHERE col IN (…) condition
  17. Get day of week in SQL Server 2005/2008
  18. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  19. SQL statement to select all rows from previous day
  20. Top n records per group sql in access
  21. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  22. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  23. SQL Select Upcoming Birthdays
  24. SQL error “ORA-01722: invalid number”
  25. Best way to do nested case statement logic in SQL Server
  26. How to count the number of occurrences of a character in an Oracle varchar value?
  27. How to use multiple CTEs in a single SQL query?
  28. How to delete duplicate rows with SQL?
  29. what is the difference between GROUP BY and ORDER BY in sql
  30. Querying Active Directory from SQL Server 2005

Leave a Comment