ALTER and DROP Statements Cross-Reference

Table 5-1 provides the full list of all objects you can change in the "big three" databases using ALTER statement.

Table 5-1: Valid ALTER Statements Cross-Reference

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.

Table 5-2: Valid DROP Statements Cross-Reference

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			ü