In this chapter, we'll describe SQL Tables in detail, and show you the syntax to use to create, alter and destroy them.
-
About SQL Tables and Views
A Schema may contain zero or more Tables. An SQL Table is a collection of r... -
Base Table
A Base table is either a Schema Object (that is, its definition is part of ... -
View
A View is a named, derived (or "virtual") Table: it doesn't physically exis... -
Table Names
A < Table name> identifies a Base table or a View. With an SQL statement, y... -
Column
A Table may contain one or more Columns. An SQL Column is a collection of s... -
CREATE TABLE statement
The CREATE TABLE statement names a new Base table and defines the Table's C... -
<Column definition>
A <Column definition> is used to create or alter a Column of a Base table.... -
<default clause>
A <default clause> defines the default value for a Column, a Domain or an a... -
ALTER TABLE statement
The ALTER TABLE statement changes a Base table's definition. The required ... -
DROP TABLE statement
The DROP TABLE statement destroys a Base table. The required syntax for the... -
CREATE VIEW statement
The CREATE VIEW statement names a new View and defines the query which, wh... -
Getting More Out Of Views
A View's virtue is that it isn't the whole picture. Something is hidden. Hi... -
DROP VIEW statement
The DROP VIEW statement destroys a View. The required syntax for the DROP V... -
DECLARE TABLE statement
The DECLARE TABLE statement names a new declared local temporary Base table... -
Dialects
Some vendors relax the rules on what may be an updatable View. For example,...
