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 | |











Recent Comments