O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required