Joe Celko's SQL for Smarties, 5th Edition

Chapter 8

Other Schema Objects

Abstract

The schema holds more than just tables. Here are some of the options, which we will discuss in detail in latter chapters.

Keywords

CREATE SCHEMA statement

Schema tables

Temporary tables

CREATE ASSERTION Statement

CREATE DOMAIN Statement

CREATE COLLATION Statement

CREATE TRANSLATION Statement

CREATE PROCEDURE Statement

CREATE TRIGGERs

DECLARE CURSOR Statement

There is a CREATE SCHEMA statement defined in the standards which bring an entire schema into existence all at once. In practice, each product has very different utility programs to allocate physical storage and define a schema.

A schema is the “skeleton” of an SQL database; it defines the structures of the schema objects and the rules under which ...