SQL chapter 6 Database management and Design

Major CREATE statements

CREATE SCHEMA CREATE TABLE CREATE VIEW other CREATE statements: CHARACTER SET COLLATION TRANSLATION ASSERTION DOMAIN

Data Control Language (DCL)

Commands that control a database, including administering privileges and committing data. ---maintenance---

Data Definition language (DDL)

Commands that define a database, including creating, altering, and dropping tables and establishing constraints. ---physical design---

Data Manipulation Language (DML)

Commands that maintain and query a database. ---implementation---

CREATE VIEW

Defines a logical table from one or more tables or views.

CREATE TABLE

Defines a new table and its columns.

CREATE SCHEMA

Defines a portion of the database owned by a particular user.

Boolean - BOOLEAN

Stores True, False, and Unkown

Temporal - TIMESTAMPTIMESTAMP WITH LOCAL TIME ZONE

Stores a moment an event occurs, using a definable fraction of a second precision. Value adjusted to the user's session time zone

String - Binary language object (BLOB)

Stores binary string values in a hexadecimal format BLOB is defined to be a variable length.

Number - NUMERIC

Stores exact numbers with a defined precision and scale.

Number - Integer (INT)

Stores exact numbers with a predefined precision and scale of zero.

String - Character (CHAR)

Stores string values containing any characters in a character set. CHAR is defined to be a fixed length.

String - character varying (VARCHAR)

Stores values containing any characters in a character set but of definable variable length.

Schema

the structure that contains descriptions of objects created by a user (base tables, views, constraints).

Catalog

A set of schemas that constitute the description of a database.