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