SQL in a Nutshell

Quick SQL Command Reference

The following list offers useful tips for reading Table 3.1, as well as what each abbreviation stands for. The sections that follow describe the table’s commands in detail:

1. The first column contains the alphabetized SQL commands.

2. The SQL statement class for each command is indicated in the second lefthand column.

3. The command’s implementation in SQL99 is indicated in the next column.

4. The subsequent columns list the vendor’s level of support:

   Supported (S)

   The vendor supports the SQL99 standard for the particular command.

   Supported, with variations (SWV)

   The vendor supports the SQL99 standard for the particular command, using vendor-specific code or syntax.

   Supported, with limitations (SWL)

   The vendor supports some but not all of the functions specified by the SQL99 standard for the particular command.

   Not supported (NS)

   The vendor does not support the particular command according to the SQL99 standard.

5. Remember that even if a specific SQL99 command is listed as “Not Supported,” the vendor usually has alternative coding or syntax to enact the same command or function. Therefore, be sure read the discussion and examples for each command later in this chapter.

Table 3-1. Alphabetical Quick SQL Command Reference

Command	SQL Statement Class	SQL99	Microsoft SQL Server	MySQL	Oracle	Postgre SQL
ALTER PROCEDURE	SQL-schema	Yes	SWV	NS	SWV	NS
ALTER TABLE	SQL-schema	Yes	SWV	SWL	SWV	SWV
ALTER TRIGGER	SQL-schema	No	SWV	NS	SWV	NS
ALTER VIEW ...