Microsoft SQL Server 2008 Bible
|
|
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 | ü |
|
|