|
SQL stands for "Structured Query Language" and is a language to
communicate with relational and object oriented databases. With SQL new tables
(relations, schemes) can be created, altered, and deleted using the
commands
CREATE TABLE
,
ALTERTABLE
and
DROP TABLE
. This part of SQL is also known as the Data Definition Language (DDL).
More important in the daily use of SQL are the data query and manipulation
(DML) commands. These commands allow you to
INSERT, DELETE, and
UPDATE
values in the database. SQL is also used to control access
restrictions to the database or to parts of it.