answersLogoWhite

0

The basic difference between DDL and DML is the commands they provide . The dml (data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables while the ddl(data description language) provides statement for the creation and deletion of tables, indexes, views etc.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What difference between dml and ddl?

The basic difference between DDL and DML is the commands they provide . The DDL provides statement for the creation and deletion of tables, indexes, views etc. while the DML provides statements to enter, update, delete and perform complex queries on these tables.


Difference between DDl DMl statement explain how savepoint work?

The differences between them you can get from, http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html


Full meaning of the acronyms dml and ddl state difference within the two?

Details is discussed on http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html


What are the sql commands with dml and ddl?

The DDL provides statement for the creation and deletion of tables, indexes, views etc. The DML provides statements to enter, update, delete and perform complex queries on these tables.


Which is fastest command dcl dml tcl ddl?

DML


Difference between ddl and dml?

DML(data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables. DDL(Data definition language) provides statements for creation and deletion of tables, view, indexes etc.


What is the full form of ddl and dml?

ddl: data definition languagedml: data manipulation language


What is DML Compiler?

What is difference between Compiler and DML Compiler


Difference between alter and update commands in sql?

Update and Alter are two SQL (Structured Query Language) commands used for modifying databases. Update statement is used to update existing records in a database. Update is a Data Manipulation Language (DML) statement. Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is a Data Definition Language (DDL) statement.Commands that are used to define the structure of a database (database schema) are called DDL statements.


What is the Componentes of dbms?

Data Definition Lenguage (DDL) Data Manipulation Lenguage (DML) Data Dictionary


Explain the DDL and DML commands in sql with example?

DDL--Data Definition Languageand Commands for DDL as:1.CREATE DATABASE--create a new data base2.ALTER DATABASE---modifies a database3.CREATE TABLE---create a new table4.ALTER TABLE---modifies a table5.DROP TABLE---deletes a table6.CREATE INDEX---creates an index(search key)7.DROP INDEX---deletes an indexDML---Data Manipulation LanguageCommands from the DML part of SQL:1.SELECT----extracts data from a database2.UPDATE--updates data in a database3.DELETE---deletes data from a database4.INSERT INTO---insert new data into a database


What are the commands of DML?

Retrieving Data,Inserting Data,and Deleting Data.