× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On Mon, Jan 25, 2016 at 9:27 AM, Vernon Hamberg
<vhamberg@xxxxxxxxxxxxxxx> wrote:
I believe it is in the 1992 standard - see this page -
http://www.frontbase.com/docs/6.3.html

Interestingly, according to the book _Understanding the New SQL: A
Complete Guide_ (written by Melton and Simon when SQL-92 was the "new
SQL"), older versions of SQL were even stricter: A "schema" was
conceived as a container for everything that a user owned; thus there
would always be exactly one schema per user. In such a system, it was
only natural that the schema name would be the same as the user name.

I don't have the book, I read excerpts from here:

https://books.google.com/books?id=ZOOMSTZ4T_QC&pg=PA63&lpg=PA63&dq=sql+92+user+schema&source=bl&ots=e0M8dHO6hx&sig=P3YwJ3B1Ur7wXjyAQKqVPZ1QgQM&hl=en&sa=X&ved=0ahUKEwj-rKvoncXKAhVGyT4KHaxCCUkQ6AEITjAI#v=onepage&q=sql%2092%20user%20schema&f=false

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.