DDL
Data Definition Language (DDL) statements
are used to define the database structure or schema. Examples:
- CREATE
- to create objects in the database
- ALTER
- alters the structure of the database
- DROP - delete objects from the database
DML
Data Manipulation Language (DML) statements
are used for managing data within schema objects. Examples:
- SELECT
- retrieve data
- INSERT
- add data
- UPDATE
- modify data
- DELETE - remove data
Note : This is not limited to SQL Server
0 comments:
Post a Comment