- 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.
0 Comments