SQL

E5275

SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.

All labels observed (22)

How this entity was disambiguated

Statements (71)

Predicate Object
instanceOf database language
programming language
query language
abbreviationOf SQL self-linksurface differs
surface form: Structured Query Language
canBeEmbeddedIn .NET languages
C
Java
PHP
Python
category ANSI standard
ISO standard
dataModel relational
designedFor relational model
domain relational database management systems
fullName SQL self-linksurface differs
surface form: Structured Query Language
hasComponent Data Control Language
Data Definition Language
Data Manipulation Language
SQL self-linksurface differs
surface form: Data Query Language
hasStandard SQL self-linksurface differs
surface form: SQL-86

SQL self-linksurface differs
surface form: SQL-89

SQL self-linksurface differs
surface form: SQL-92

SQL:1999
SQL self-linksurface differs
surface form: SQL:2003

SQL self-linksurface differs
surface form: SQL:2006

SQL self-linksurface differs
surface form: SQL:2008

SQL self-linksurface differs
surface form: SQL:2011

SQL self-linksurface differs
surface form: SQL:2016

SQL self-linksurface differs
surface form: SQL:2019
influencedBy SQL self-linksurface differs
surface form: SEQUEL
introducedInDecade 1970s
originatedAt IBM
paradigm declarative
primaryUse controlling access to data
defining database schemas
managing data in relational databases
manipulating data in relational databases
querying data in relational databases
standardizedBy ANSI
International Organization for Standardization
surface form: ISO
supportsFeature constraints
joins
stored procedures
subqueries
transactions
triggers
views
supportsOperation ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE VIEW
DELETE
DROP TABLE
GRANT
INSERT
REVOKE
SELECT
UPDATE
usedBySystem IBM DB2
surface form: IBM Db2

MariaDB
SQL Server
surface form: Microsoft SQL Server

MySQL
Oracle Database
PostgreSQL
SQLite
usedFor OLAP systems
OLTP systems
analytics
business applications
data warehousing
reporting

How these facts were elicited

Referenced by (74)

Full triples — surface form annotated when it differs from this entity's canonical label.

DSC hasTopic SQL
SQL Server Agent canBeManagedWith SQL
this entity surface form: Transact-SQL
DQS Server language SQL
this entity surface form: T-SQL
System R mainSubject SQL
this entity surface form: structured query language
System R implementedFeature SQL
this entity surface form: SQL query language
TQuery hasProperty SQL
java.sql supports SQL