O'Reilly logo

Sams Teach Yourself J2EE™ in 21 Days by Peter Roxburgh, Andy Longshaw, Debbie Law, Dan Haywood, Martin Bond

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required