Sams Teach Yourself J2EE™ in 21 Days

Commonly Used SQL Statements (SQL99)

The following provides a reference to the SQL statements that you might use on a day-to-day basis. It does not intend to provide a complete reference, and it also does not aim to illustrate vendor implementation-specific syntax. For a fuller reference or an exact guide to your chosen RDBMS, please refer to your vendor's documentation.

ALTER TABLE

 ALTER TABLE table_name { ADD [COLUMN] column_name datatype attributes | ALTER COLUMN column_name SET DEFAULT default_value | ALTER COLUMN column_name DROP DEFAULT | ALTER COLUMN column_name ADD SCOPE table_name | ALTER COLUMN column_name DROP SCOPE [RESTRICT | CASCADE] | DROP COLUMN column_name [RESTRICT | CASCADE] | ADD table_constraint_name | DROP CONSTRAINT table_constraint_name ...