Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is "Structured" in Structured Query Language?

What does the "Structured" word means in SQL?

Is it because this(SQL) language statements are organized into Clauses, expressions and predicates?

Because of this organization, is it called "Structured" ?

like image 531
fr21 Avatar asked May 30 '10 14:05

fr21


People also ask

What is Structured Query Language statement?

Structured Query Language (SQL) is a specialized programming language designed for interacting with a database. SQL allows us to perform three main tasks: To define the scope of the database. To add, delete or modify the data in the database. To read data from the database.

What is the structure of a SQL query?

SQL includes Data Definition Language (DDL) statements and Data Manipulation Language (DML) statements. DDL statements, such as CREATE, ALTER, and DROP, modify the schema of a database. DML statements, such as SELECT, INSERT, UPDATE, and DELETE, manipulate data in tables.

Why SQL is called as structured language?

The original full name was SEQUEL, which stood for "Structured English Query Language". It later had to be renamed to SQL due to trademark issues. So basically, it was yet another attempt to sell a programming language as "just like English, except with a formal syntax" (hence "structured").

What are the types of Structured Query Language?

In the year 1974, the term Structured Query Language appeared. Five types of SQL queries are 1) Data Definition Language (DDL) 2) Data Manipulation Language (DML) 3) Data Control Language(DCL) 4) Transaction Control Language(TCL) and, 5) Data Query Language (DQL)


2 Answers

The original full name was SEQUEL, which stood for "Structured English Query Language". It later had to be renamed to SQL due to trademark issues.

So basically, it was yet another attempt to sell a programming language as "just like English, except with a formal syntax" (hence "structured").

like image 93
Michael Borgwardt Avatar answered Oct 28 '22 01:10

Michael Borgwardt


As I understand it, SQL is actually an abbreviation of SEQUEL, or Structured English Query Language. It was meant to have queries that everyone could read. The structured part means that you can only use a structured English; i.e. select col1 from table1, but not give col1 out of table1.

like image 45
Andomar Avatar answered Oct 28 '22 02:10

Andomar