Skip to main content

Posts

Showing posts with the label DCL

Database Languages in DBMS – DDL, DML, DCL, DQL Jitendra Ajmera The Crazy Programmer

Programming languages which are used to create and operate database, known as database language like Structured Query language aka SQL etc. Most of database languages are non-procedural, means the language focus on “what to do instead of how to do?” We can further divide database languages in these 4 categories as per the type of users: Data definition language aka DDL Data manipulation language aka DML Data control language aka DCL Data query language aka DQL DDL It is used to specify or create database schema like new database or tables creation along with their properties. It is commonly used by Database administrator. Sample codes are as per given below: CREATE : To create new database or tables ALTER : To change the structure of table DROP : To delete objects from table TRUNCATE : To remove all records from a table COMMENT : To add comments to the data dictionary It also updates data dictionary. Data dictionary is kind of metadata about the database. In simple