Re: What's the CURRENT schema ?

Hiroshi Inoue wrote:
>
> > You misunderstood what I've said. You may have how many schemas
> > you please. But you will have to refer to their objects specifying
> > the schema name explicitly. The only cases where you can omit the
> > schema name are (accordingly to the SQL'99 standard):
>
> Please tell me where's the description in SQL99 ?
> I wasn't able to find it unfortunately.
>

As most things in the SQL standard, you have to collect information
from several places and add it together.

Look at 4.20, 11.1 and specially at the rules for
<schema qualified name>.

Then think a little bit about scenarios, trying to apply the rules.

It is a pain, but there is no other way.

--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9