Definition of Schema and Catalog (which schema to use)

Andrew Douglas Pitonyak <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
While creating a table using the latest development build, I was asked 
which schema should contain the table. My two choices were  
INFORMATION_SCHEMA and PUBLIC. Which schema should I use and why? The 
default is INFORMATION_SCHEMA.

My expectation was that it should be stored in PUBLIC, but the default 
is the other. I was not able to actually create the tables to see if I 
could notice a difference, because the table creation wizard always 
crashed when I selected Finish. Then again, the wizard had some other 
problems as well :-(

This lead me to ask, what is the definition of CATALOG and SCHEMA, as 
they relate to OpenOffice.org.




-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info:  http://www.pitonyak.org/oo.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.