creates a view with constraints

creates a view even if the underlying parent table has constraints

creates a view in another schema even if you don't have privileges

creates a view regardless of whether or not the base tables exist