SQL Parts
-
Data-Definition Language (DDL)
Provides commands for defining relation schemas, deleting relations, and modifying relation schemas.
-
Data-Manipulation Language (DML)
Provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database.
-
Integrity
Provides commands for specifying integrity constraints that the data stored in the database must satisfy.
-
View Definition
Provides commands for defining views.
-
Transaction Control
Provides commands for specifying the beginning and ending of transactions.
-
Embedding SQL & Dynamic SQL
Define how SQL statements can be embedded within general-purpose programming languages.
-
Authorisation
Provides commands for specifying access rights to relations and views.