Home
Topics
Storage and Data Management
Database
Data Definition Language (DDL)

Definition

Data Definition Language (DDL)

Part of the Database glossary:

Data Definition Language (DDL) is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP.

Next Steps

What are DDL and DML?
What are DDL and DML and their commands?
(SearchOracle.com)
What is the difference between data definition language (DDL) and SQL?
Learn the difference between a data definition ...
(SearchDataManagement.com)

Learn more:

Mark Whitehorn explains the difference between data definition language (DDL) and data manipulation language (DML).

This was last updated in April 2009

Posted by: Margaret Rouse

Related Terms

Definitions

Amazon Dynamo Database (DDB)
- Amazon Dynamo Database (DDB) is a fully-managed NoSQL database service. Dynamo Database is known for extremely low latencies and scalability. (WhatIs.com)
Amazon Relational Database Service (RDS)
- Amazon Relational Database Service (RDS) is a fully-managed SQL database service. Amazon RDS offers an array of database engine choices to help with database management tasks such as migration, bac... (WhatIs.com)
Redis
- Redis is an open source key-value database sponsored by VMware. (WhatIs.com)

Glossaries

Database
- Terms related to databases, including definitions about relational databases and words and phrases about database management.
Internet applications
- This WhatIs.com glossary contains terms related to Internet applications, including definitions about Software as a Service (SaaS) delivery models and words and phrases about web sites, e-commerce ...

Dig Deeper

What are DDL and DML?

What are DDL and DML and their commands? (SearchOracle.com)
What is the difference between data definition language (DDL) and SQL?

Learn the difference between a data definition language (DDL), also known as data descriptive language, and the Structured Query Language (SQL). Find examples of both DDL and SQL. (SearchDataManagement.com)
SQL Server 2005 DDL vs. DML triggers

SQL Server 2005 adds a new type of trigger -- DDL (Data Definition Language) triggers. Find out how they compare to "normal" DML triggers in this expert response. (SearchSQLServer.com)

People Who Read This Also Read...

Ask a Question. Find an Answer.Powered by ITKnowledgeExchange.com

Ask An IT Question

Get answers from your peers on your most technical challenges

Tech TalkComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

( View All TechTarget Sites )

CIO
Compliance
VMware
Storage
Security
IT Channel
Financial and HR Applications
Windows Server

CIO

( Find Out More About This Site )
- glocalization
  
  Glocalization is the concept that in a global market, a product or service is more likely to succeed when it is customized for the locality or culture in which it is sold.
- Vine (Vine app)
  
  Vine is a free mobile application that enables users to record and share an unlimited number of short, looping video clips with a maximum length of six seconds.
- Google Wallet
  
  Google Wallet is a mobile payment system developed by Google that allows smartphone users to store debit and credit card information for online and in-store purchases.
Compliance

( Find Out More About This Site )
- AICPA (American Institute of Certified Public Accountants)
  
  The AICPA (American Institute of Certified Public Accountants) is a member association for the accounting profession that sets ethical standards for accountants, as well as U.S. auditor standards for private companies, nonprofit organizations and the government.
- FTC (Federal Trade Commission)
  
  The FTC (Federal Trade Commission) is a U.S. federal regulatory agency designed to monitor and prevent anticompetitive, deceptive or unfair business practices.
- geolocation data
  
  Geolocation data is information associated with an electronic device that can be used to identify its physical location. The most common example of geolocation data is an IP address.
VMware

( Find Out More About This Site )
- vNUMA (virtual NUMA)
  
  vNUMA (virtual NUMA) is a memory-access optimization method for VMware virtual machines (VMs) that helps prevent memory-bandwidth bottlenecks.
- VMware host profile
  
  VMware Host Profiles is a vCenter Server tool to design and deploy ESX/ESXi hosts.
- VMware NSX
  
  VMware NSX is a virtual networking and security software product family created from VMware's vCloud Networking and Security (vCNS) and Nicira Network Virtualization Platform (NVP) intellectual property.
Storage

( Find Out More About This Site )
- storage hypervisor
  
  A storage hypervisor, also called software-defined storage, is a marketing term for software that allows storage to be controlled centrally in a storage pool regardless of what hardware the storage is located on.
- I/O contention (input/output contention)
  
  I/O contention (input/output contention), occurs when virtual machines compete for I/O resources because there is a limited storage bandwidth.
- erasure coding
  
  Erasure coding (EC) is a method of data protection in which data is broken into fragments, expanded and encoded with redundant data pieces, and stored across a set of different locations, such as disks, storage nodes or geographic locations.
Security

( Find Out More About This Site )
- computer forensics (cyber forensics)
  
  Computer forensics is the application of investigation and analysis techniques to gather and preserve evidence from a particular computing device in a way that is suitable for presentation in a court of law.
- multifactor authentication (MFA)
  
  Multifactor authentication (MFA) is a security system in which more than one form of authentication is implemented to verify the legitimacy of a transaction... (Continued)
- security information and event management (SIEM)
  
  Security information and event management (SIEM) is an approach to security management that seeks to provide a holistic view of organization’s information technology (IT) security.
IT Channel

( Find Out More About This Site )
- Apple Authorized Service Provider (Apple ASP)
  
  An Apple Authorized Service Provider (Apple ASP) is an individual or organization that can legally service Apple products although their warranties are held by other entities. Service by anyone other than an authorized service provider (ASP) will render a product's warranty void.
- authorized service provider (ASP)
  
  An authorized service provider (ASP) is an individual or an organization that is permitted to service products that are covered by warranties held by another entity. Service conducted by anyone other than an authorized service provider will generally render a warranty void.
- hosted services
  
  Hosted services are outsourced information technology (IT) systems and functions. A hosted service provider owns and oversees infrastructure, software and administrative tasks and makes the system available to clients, usually over the Internet.
Financial and HR Applications

( Find Out More About This Site )
- Automatic Data Processing Inc. (ADP)
  
  Automatic Data Processing Inc. (ADP) is a global business outsourcing services provider headquartered in Roseland, N.J.
- Kronos Inc.
  
  Kronos Inc. is a provider of workforce management software and associated services headquartered in Chelmsford, Mass.
- BPaaS (Business Process as a Service)
  
  Business Process as a Service (BPaaS) is a form of business process outsourcing (BPO) that employs a cloud computing service model.
Windows Server

( Find Out More About This Site )
- Microsoft FIM (Microsoft Forefront Identity Manager)
  
  Microsoft Forefront Identity Manager (FIM) is a self-service identity management software suite.
- Microsoft Software Assurance (SA)
  
  Microsoft Assurance Software is a program that was introduced in 2002 to help users with the maintenance of Microsoft Windows, Microsoft Office and applications for the server and desktop.
- DCPromo (Domain Controller Promoter)
  
  DCPromo (Domain Controller Promoter) is a tool in Active Directory that installs and removes Active Directory Domain Services and promotes domain controllers.

All Rights Reserved,Copyright 1999 - 2013, TechTarget