Home > SQL > SQL - Lez. 2: Data types and keywords

SQL - Lez. 2: Data types and keywords

Requirements: no requirements

In this lecture we will present the SQL data types and provide a list of language keywords.

Data Types

There are three main types of data:

  • Numbers;
  • Characters;
  • Time;

The first category those represented by integers or floating point.
In the second category, we can enclose individual characters or strings.
In the latter case, enclose the dates, times and intervals.

SQL reserved words

Below is a list of SQL reserved words. With Reserved words are words that interprets the language as instructions and common strings.

ABSOLUTE BEFORE
ACTION BEGIN
ACTOR BETWEEN
ADD BIT
AFTER BIT_LENGTH
ALIAS BOOLEAN
ALL BOTH
ALLOCATE Breadth
ALTER BY
AND CASCADE
ANY CASCADED
AER CASE
AS CAST
ASC CATALOG
ASSERTION CHAR
ASYNC CHAR_LENGTH
AT CHARACTER
ATTRIBUTES CHARACTER_LENGTH
AUTHORIZATION CHECK
AVG CLASS
CLOSE CURRENT_PATH
COALESCE CURRENT_TIME
COLLATE CURRENT_STAMP
COLLATION CURRENT_USER
COLUMN CURSOR
COMMIT CYCLE
Completion DATE
CONNECT DATES
CONNECTION DAY
CONSTRAINT DEALLOCATE
CONSTRAINTS DEC
CONSTRUCTOR DECIMAL
CONTINUE DECLARE
CONVERT DEFAULT
Corresponding DEFERRABLE
COUNT DEFERRED
CREATE DELETE
CROSS DEPTH
CURRENT DESC
CURRENT_DATE DESCRIBE
DESCRIPTOR

Designator

DESTROY

Destructor

DIAGNOSTICS

DICTIONARY

DISCONNECT


Tag: , Categories: SQL Tags: ,
  1. No comments yet ...
  1. No trackbacks yet ...
Immagine CAPTCHA
Audio CAPTCHA
Change image
*