>> AFAIU, this is possible with synonyms only but the SQL specification has
>> no such a feature. Nobody said we should follow exactly the Oracle's
>> implementation.
>
> What would you say about mandatory indication of schema in SQL
> queries? If now I can just write "select * from a_table", with schemas
> I'll have to write "select * from some_schema_name.a_table".
> Sometimes I am lazy too, so I don't like unnecessary typing.
>
> SY, SD.
>
> PS: All your meaningful examples of schema usage are covered by
> replication.

Procedural Pascal was great, it was much better than plain machine language.

Yet, this hasn't stopped the development and adoption of Object Pascal...

Let alone Delphi ;-)


In short: even though you can develop what you want using procedural
Pascal, does that mean Object Pascal shouldn't have been developed?

Just because you can think of terrible examples with Schemas, does that
mean Schemas cannot be put to good use?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com