Data Definition Language (or)
Data Description Language
Data Description Language
Ø
DDL is a kind of
programming language which helps to create Database objects like ...
Table
Columns
object Relationships
Views
Procedures
Functions
Indexes
Packages
Triggers
Types
Synonyms
Database
Linked Objects
Security
etc.,
Ø
The Script which is used to create db objects like above also called as Schema which will be stored in Data Dictionary
Ø
DDL will be
supported by Database Management Systems (DBMS)
Ø
The script which
helps to create/define/Modify/Remove an objects in DB will be part of DDL
Ø
Following are the
general DDL Commands...
o
CREATE - To
create New objects in a database
o
ALTER - Modify
the structure of Existing objects database
o
DROP -
Delete/Remove an objects from the database
o
TRUNCATE - Remove
the data page which is attached to a table object,
o
COMMENT - Add
comments to the Data dictionary
o
RENAME - rename
an Existing DB object
o
SELECT ... INTO -
Creating new object by using existing object schema, it will not capture
identity definition and field relationship
No comments:
Post a Comment