Subject Re: [Firebird-Architect] Schemas
Author Alexander Peshkoff
On Thursday 24 September 2009 15:13:59 Dimitry Sibiryakov wrote:
> > 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.

IMO current schema should exist, be selectable and select from tables in it
should not require it's name.

BTW, when inviting tricks to design big databases w/o schema (I had ot use
underscore a few years ago, something like COMMON_DOC and ZPL_DOC), I had to
write COMMON_ and ZPL_ always...