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@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9