Data Definition Language Article Index for
Data 		Shopping
Definition 		Website Links For
Data 		 

Information About

Data Definition Language
  CATEGORIES ABOUT DATA DEFINITION LANGUAGE
   
sql
   
data modeling languages
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...



For example in Oracle the DDL statements refer to CREATE, DROP, ALTER, etc..

These SQL statements define the structure of a Database , including rows, columns, tables, indexes, and database specifics such as file locations. DDL SQL statements are more part of the DBMS and have large differences between the SQL variations. DDL SQL commands include the following:

  • Create - To make a new database, table, index, or stored query.

  • Drop - To destroy an existing database, table, index, or view.

  • Alter - To modify an existing database object.


DBCC (Database Console Commands) - Statements check the physical and logical consistency of a database.


SEE ALSO