SQL (Structured Query Language) . SQL , 70- IBM Research. IBM System R. "-" .
SQL 1989 . ( SQL/89 SQL1). SQL1 ANSI/ISO, . , , SQL.
1992 . SQL, SQL/92 SQL2. , , SQL/89. , SQL2.
1999 , SQL3. SQL1 SQL2 , SQL3 . SQL3 , , . , , , , . . SQL, . , (savepoints), ROLLBACK , . .
SQL
, , SQL , , , Data Definition Language (DDL) . , , () .
SQL , . 1:
|
SQL92 :
- CHARACTER(n) CHAR(n) n . n , , n , .
- NUMERIC[(n,m)] , n , m .
- DECIMAL[(n,m)] , n , m .
- DEC[(n,m)] , DECIMAL[(n,m)].
- INTEGER INT .
- SMALLINT .
- FLOAT[(n)] , . n , . .
- REAL , , , FLOAT.
VARCHAR(n) .
BIT(n) .
- BIT VARYING(n) .
- DATE .
- TIMESTAMP() .
- INTERVAL .