لطفا منتظر باشید ...
CREATE Statement Cross-Reference
Table 4-1 provides the full list of all objectsyou 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.
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.
