> And since the "*" forms are considered bad style I have done this, not knowing it is bad style. Can you provide some reasons why it is bad? I can assume, "Applications are supposed to be controlled environments, and using tbl.* introduces uncertainty outside the applications control." But are there more specific reasons?
Thanks,dvn On Mon, Nov 21, 2016 at 3:09 PM, Richard Hipp <d...@sqlite.org> wrote: > On 11/21/16, David Raymond <david.raym...@tomtom.com> wrote: > > > > Following the nice SQL diagrams it looks like in a select you can only > have > > * or table-name.*, whereas in other places you can have > > schema-name.table-name. Granted, the second version can be made prettier > and > > more readable, but I would have assumed the first version would be ok. Is > > this par for all SQL versions? > > I don't know what other database engines do, but you are correct that > SCHEMA.TABLE.* is not allowed in SQLite. And since the "*" forms are > considered bad style (to be used only interactively, and not in > applications) we are not motivated to change it, lest developers be > tempted to use "*" in their applications. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users