Table 5-1 provides the full list of all objects you can change in the "big three" databases using ALTER statement.
|
Statement |
SQL99 |
Oracle 9i |
DB2 UDB 8.1 |
MS SQL Server 2000 |
|---|---|---|---|---|
|
ALTER BUFFERPOOL |
ü | |||
|
ALTER CLUSTER |
ü | |||
|
ALTER DATABASE |
ü |
ü |
ü |
|
|
ALTER DIMENSION |
ü | |||
|
ALTER DOMAIN |
ü | |||
|
ALTER FUNCTION |
ü |
ü |
||
|
ALTER INDEX |
ü | |||
|
ALTER INDEXTYPE |
ü | |||
|
ALTER JAVA |
ü | |||
|
ALTER MATERIALIZED VIEW |
ü | |||
|
ALTER MATERIALIZED VIEW LOG |
ü | |||
|
ALTER NICKNAME |
ü | |||
|
ALTER NODEGROUP |
ü | |||
|
ALTER OUTLINE |
ü | |||
|
ALTER PACKAGE |
ü | |||
|
ALTER PROCEDURE |
ü | |||
|
ALTER PROFILE |
ü | |||
|
ALTER RESOURCE COST |
ü | |||
|
ALTER ROLE |
ü | |||
|
ALTER ROLLBACK SEGMENT |
ü | |||
|
ALTER SEQUENCE |
ü |
ü | ||
|
ALTER SERVER |
ü | |||
|
ALTER SESSION |
ü | |||
|
ALTER SPFILE |
ü | |||
|
ALTER SYNONYM |
ü | |||
|
ALTER SYSTEM |
ü | |||
|
ALTER TABLE |
ü |
ü |
ü |
ü |
|
ALTER TABLESPACE |
ü |
ü | ||
|
ALTER TRANSLATION |
ü | |||
|
ALTER TRIGGER |
ü |
ü |
||
|
ALTER TYPE |
ü |
ü |
ü | |
|
ALTER USER |
ü | |||
|
ALTER USER MAPPING |
ü | |||
|
ALTER VIEW |
ü |
ü |
ü |
ü |
Table 5-2 provides the full list of all objects you can remove using a DROP statement.
|
Statement |
SQL99 |
Oracle 9i |
DB2 UDB 8.1 |
MS SQL Server 2000 |
|---|---|---|---|---|
|
DROP ALIAS |
ü | |||
|
DROP ASSERTION |
ü | |||
|
DROP BUFFERPOOL |
ü | |||
|
DROP CHARACTER SET |
ü | |||
|
DROP CLUSTER |
ü | |||
|
DROP COLLATION |
ü | |||
|
DROP CONTEXT |
ü | |||
|
DROP DATABASE |
ü |
ü |
||
|
DROP DATABASE LINK |
ü | |||
|
DROP DEFAULT |
ü |
|||
|
DROP DIMENSION |
ü | |||
|
DROP DIRECTORY |
ü | |||
|
DROP DISTINCT TYPE |
ü | |||
|
DROP DOMAIN |
ü | |||
|
DROP EVENT MONITOR |
ü | |||
|
DROP FUNCTION |
ü |
ü |
ü |
|
|
DROP FUNCTION MAPPING |
ü | |||
|
DROP INDEX |
ü |
ü |
ü |
|
|
DROP INDEX EXTENSION |
ü | |||
|
DROP INDEXTYPE |
ü | |||
|
DROP JAVA |
ü | |||
|
DROP LIBRARY |
ü | |||
|
DROP MATERIALIZED VIEW |
ü | |||
|
DROP MATERIALIZED VIEW LOG |
ü | |||
|
DROP METHOD |
ü | |||
|
DROP NICKNAME |
ü | |||
|
DROP NODEGROUP |
ü | |||
|
DROP OPERATOR |
ü | |||
|
DROP OUTLINE |
ü | |||
|
DROP PACKAGE |
ü |
ü | ||
|
DROP PROCEDURE |
ü |
ü |
ü |
|
|
DROP PROFILE |
ü | |||
|
DROP ROLE |
ü |
ü | ||
|
DROP ROLLBACK SEGMENT |
ü | |||
|
DROP RULE |
ü |
|||
|
DROP SCHEMA |
ü |
ü | ||
|
DROP SEQUENCE |
ü |
ü | ||
|
DROP SERVER |
ü | |||
|
DROP STATISTICS |
ü |
|||
|
DROP SYNONYM |
ü | |||
|
DROP TABLE |
ü |
ü |
ü |
ü |
|
Statement |
SQL99 |
Oracle 9i |
DB2 UDB 8.1 |
MS SQL Server 2000 |
|
DROP TABLESPACE |
ü |
ü | ||
|
DROP TABLE HIERARCHY |
ü | |||
|
DROP TRANSFORM |
ü | |||
|
DROP TRANSLATION |
ü | |||
|
DROP TRIGGER |
ü |
ü |
ü |
|
|
DROP TYPE |
ü |
ü |
ü | |
|
DROP TYPE BODY |
ü | |||
|
DROP TYPE MAPPING |
ü | |||
|
DROP USER |
ü | |||
|
DROP USER MAPPING |
ü | |||
|
DROP VIEW |
ü |
ü |
ü |
ü |
|
DROP VIEW HIERARCHY |
ü | |||
|
DROP WRAPPER |
ü |