Workarounds that Use the Keyword AS

In some cases, although a statement is not ambiguous and the syntax is correct, the database server returns a syntax error. The preceding pages show existing syntactic workarounds for several situations. You can use the AS keyword to provide a workaround for the exceptions.

You can use the AS keyword in front of column labels or table aliases.

The following example uses the AS keyword with a column label:

SELECT column_name AS display_label FROM table_name;

The following example uses the AS keyword with a table alias:

SELECT select_list FROM table_name AS table_alias;