SQL - Data Definition / Data Dictionary Language (DDL)

Data System Architecture

About

Data definition language (DDL) is a category of statement that manipulate the data dictionary of a database.

The three principal commands are:

  • CREATE,
  • ALTER,
  • and DROP

but you can also find:

  • TRUNCATE to remove all records from a table, including all spaces allocated for the records are removed
  • COMMENT to add comments to the data dictionary
  • RENAME to rename an object
  • GRANT privileges on object
  • REVOKE privileges on object
  • FLASHBACK restores an earlier version of a table or database
  • PURGE removes database objects from the recycle bin
  • COMMENT on a particular object
  • ANALYZE
  • AUDIT
  • ASSOCIATE
  • STATISTICS
  • DISASSOCIATE
  • NOAUDIT





Discover More
Data System Architecture
Database - Migration (Deployment|Versioning|Change Management)

with SQL database. Database migration is the process of changing the structure of the database in an other with mostly DDL statement. The flow sometimes will block any change that risks data-loss. See...
Card Puncher Data Processing
Glossary

(CREATE, ALTER, DROP) (GRANT, REVOKE) (SELECT, UPDATE, INSERT, DELETE) (COMMIT, ROLLBACK) NLS (National Language Support) UDML is the abbreviation for Universal Database Markup Language ...
Card Puncher Data Processing
Java DB - dblook

The Derby dblook utility is a Data Definition Language (DDL) generation utility. where: -d option is the full connection URL to the Network Server database.
Jdbc Class Architecture
Jdbc - Statement

Statement objects are created by Connection objects The java/sql/StatementStatement interface defines methods for executing SQL statements. There is also two subclasses: The PreparedStatement interface...
Bi Server Architecture With Client
OBIEE 10G/11G - persist connection pool

A persist connection pool is a database property that is used for specific types of queries (typically used to support Marketing queries). In some queries, all of the logical query cannot be sent to...
Card Puncher Data Processing
Oracle - Partitions (Table and Indexes)

partition in Oracle. Partitioning enables you to store one logical object – a table or index – transparently in several independent segments. Partitioning can provide great performance improvements...
Card Puncher Data Processing
Oracle Database - DDL Locks (data dictionary lock)

A data dictionary (DDL) lock protects the definition of a schema object while an ongoing DDL operation (CREATE, ALTER, DROP) acts on or refers to the object. Only individual schema objects that are modified...
Card Puncher Data Processing
Oracle Database - Explain Plan

EXPLAIN PLAN is an Oracle SQL Command that tell you what the query plan for a given SQL would be : if executed it right now in the current session with the current settings For this purpose, it...
Toad Lock
Oracle Database - Locks

Lock Mechanism in Oracle Oracle Database provides: data concurrency, consistency. The data a session is viewing or changing must not be changed by other sessions until the user is finished. and...
Oracle Database Sql Parallel Execution Principle
Oracle Database - SQL Parallel Execution

Parallel execution was first introduced in Oracle Version 7.3 in 1996 Oracle will make use of Parallel when a table or a statement is marked as “Parallel”. The concept of parallelism is when many...



Share this page:
Follow us:
Task Runner