Explain DDL
In : BCA Subject : Data Manipulation and Analysis (DMA)Data Definition Language (DDL)
- Used to specify a database scheme as a set of definitions expressed in a DDL
- DDL statements are compiled, resulting in a set of tables stored in a special file called a data dictionaryor data directory.
- The data directory contains metadata(data about data)
- The storage structure and access methods used by the database system are specified by a set of definitions in a special type of DDL called a data storage and definitionlanguage
- basic idea: hide implementation details of the database schemes from the users