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.