dadbsq00 | database

Structured query Language (SQL);
A command string used to extract or update data in a database.

Structured Query Language is the most common approach to view data in a database.
SQL is currently an international standard for relational databases.
Open Database Connectivity (ODBC) uses SQL.
MS-Access uses SQL to store it's queries
Oracle (SQL*Plus), Informix uses (iSQL) and Progress have special modules to access its database via SQL.
Microsoft have a database server (MS-SQL Server) specifically built to handle SQL commands.

For Example:

SELECT * FROM premp
Select all records from the employee payroll table - premp)

SQL always produces a SET of data, which is basically a rectangular block of rows (records) and columns (fields). The data is produced at the same level of summarisation, so the output (table returned) of an SQL query will NOT allow control breaks.

	Language	Examples
DDL	Data Definition Language	Create table, Create index etc
DCL	Data Control Language.	Grant, Revoke
DML	Data Manipulation Language	Insert, Delete, Update
DQL	Data Query Language.	Select.
TPL	Transaction Processing	Begin work, Rollback, Commit

Structured query language (SQL)

For Example:

SQL Components