O'Reilly logo

SQL in a Nutshell by Kevin Kline

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

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

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