There are number of commands in database (SQL) that are used to control , manipulate , retrieve data. One such command is DDL which is used for defining the schema of database.
DDL Interpreters are computer programs designed to process and execute Data Definition Language (DDL) statements. These statements are used to create, modify, and delete database structures such as tables, indexes, and constraints. DDL Interpreters play a crucial role in managing the database schema and ensuring data integrity.
Data definition language (DDL) component enables database administrators (DBAs) to define the schema components, including tables, indexes, views, and constraints within a database. With DDL, users can create, modify, and delete the structure of the database to ensure data integrity and organization.
"Interpret" means to explain or translate something, often language or communication, from one form to another in order to make it understandable or clarify its meaning.
The three languages adopted by the Database Task Group (DBTG) were Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). These languages formed the basis for standardized data management within the DBTG framework.
The three languages adopted by the Database Task Group (DBTG) are Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). These languages help define the structure of databases, manipulate data within databases, and control access permissions to the data.
SQL (Structured Query Language) enables a database administrator to define schema components, such as tables, columns, indexes, and relationships in a database. By using SQL commands like CREATE TABLE, ALTER TABLE, and CREATE INDEX, administrators can create and modify the structure of a database according to their requirements.
DDL stands for Data Definition Language, and so it follows that creating a table is DDL, creating a view is DDL and so on.
Full form of the DDL is Data Definition Language.
ddl stands for Data Definaton Language.Eg:- Create ,Alter .Drop.Truncate Why we have called it as DDL means.... we are defining or acting at structure level. Say, when ever you create a table we are dealing at strucutre level. Hence its is DDL
ddl: data definition languagedml: data manipulation language
DDL compiler is the compiler whose job is to convert high level commands to low level commands..
Remarkable to say
forshared
no, they are free
i dont now
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
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.
The differences between them you can get from, http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html