• DDL stands for ‘Data definition language’.
  • DDL is subset of SQL and is a part of DBMS.
  • DDL statements are the collection of those SQL commands which are used to create and manipulate the structures of a database/schema i.e. they are used to create database objects like databases, tables, users, constraints, indexes, views, triggers etc.
  • In another words, DDL statements are used to create database schema and to define the data type and structure of the data that will be stored in a database finally.
  • These statements define the data structure of database Schema.
  • Some common DDL statements/commands are CREATE, ALTER, DROP, TRUNCATE, RENAME, REVOKE, GRANT etc.


Categories: SQL


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.