Subset of SELECT Statements Valid in View Definitions

You cannot create a view on a temporary table. The FROM clause of the SELECT statement cannot include the name of a temporary table.

If Select privileges are revoked from a user for a table that is referenced in the SELECT statement defining a view that the same user owns, then that view is dropped, unless it also includes columns from tables in another database.

You cannot create a view on typed tables (including any table that is part of a table hierarchy) that reside in a remote database.

Do not use display labels in the select list of the Projection clause. Display labels in the Projection clause are interpreted as column names.

The SELECT statement in CREATE VIEW cannot include the SKIP, FIRST, or LIMIT keywords, the INTO TEMP clause, or the ORDER BY clause. For complete information about SELECT statement syntax and usage, see SELECT.