CREATE Statement Cross-Reference

Table 4-1 provides the full list of all objects you can create in the "big three" databases as well as SQL99 CREATE statement standards. Some of the statements were covered in this chapter; some others will be covered later in this book. For example, we'll talk about CREATE USER, CREATE ROLE, and CREATE PROFILE statements in Chapter 12.

Table 4-1: Valid CREATE Statements Cross-Reference

Statement	SQL99	Oracle 9i	DB2 UDB 8.1	MS SQL Server 2000
CREATE ALIAS			ü
CREATE ASSERTION	ü
CREATE BUFFERPOOL			ü
CREATE CHARACTER SET	ü
CREATE CLUSTER		ü
CREATE COLLATION	ü
CREATE CONTEXT		ü
CREATE CONTROLFILE		ü
CREATE DATABASE		ü	ü	ü
CREATE DATABASE LINK		ü
CREATE DEFAULT				ü
CREATE DIMENSION		ü
CREATE DIRECTORY		ü
CREATE DISTINCT TYPE			ü
CREATE DOMAIN	ü
CREATE EVENT MONITOR			ü
CREATE FUNCTION		ü	ü	ü
CREATE FUNCTION MAPPING			ü
CREATE INDEX		ü	ü	ü
CREATE INDEX EXTENSION			ü
CREATE INDEXTYPE		ü
CREATE JAVA		ü
CREATE LIBRARY		ü
CREATE MATERIALIZED VIEW		ü
CREATE MATERIALIZED VIEW LOG		ü
CREATE METHOD			ü
CREATE NICKNAME			ü
CREATE NODEGROUP			ü
CREATE OPERATOR		ü
CREATE OUTLINE		ü
Statement	SQL99	Oracle 9i	DB2 UDB 8.1	MS SQL Server 2000
CREATE PACKAGE		ü	ü
CREATE PACKAGE BODY		ü
CREATE PFILE		ü
CREATE PROCEDURE		ü	ü	ü
CREATE PROFILE		ü
CREATE ROLE	ü	ü
CREATE ROLLBACK SEGMENT		ü
CREATE RULE				ü
CREATE SCHEMA	ü	ü	ü	ü
CREATE SEQUENCE		ü	ü
CREATE SERVER			ü
CREATE SPFILE		ü
CREATE STATISTICS				ü
CREATE SYNONYM		ü
CREATE TABLE	ü	ü	ü	ü
CREATE TABLESPACE		ü	ü
CREATE TEMPORARY TABLESPACE		ü
CREATE TRANSFORM			ü
CREATE TRANSLATION	ü
CREATE TRIGGER		ü	ü	ü
CREATE TYPE	ü	ü	ü
CREATE TYPE BODY		ü
CREATE TYPE MAPPING			ü
CREATE USER		ü
CREATE USER MAPPING			ü
CREATE VIEW	ü	ü	ü	ü
CREATE WRAPPER			ü

Many CREATE statements are for database administrators use only, so you will not find their detailed explanation in the book; refer to vendor-specific documentation for more information.