what is database languages and what is DML DDL and DCL in SQL
DATABASE LANGUAGES (1) DATA DEFINITION LANGUAGE (DDL) -- the language used to define database is known as data definition language (DDL). The command used for defining database are known as DDL command. DDL includes all commands used for altering tables, dropping tables and defining constrains. (2) DATA MANIPULATION LANGUAGE (DML) -- the language that enable users to access or manipulate data is known as data manipulation language. The commands used for accessing and manipulating data are known as DML commands. DML includes commands for insertion, deletion, and updation besides retrieval. DMLs basically two types : * procedural DMLs : it requires user to...
Comments
Post a Comment