Ed Leafe wrote: > On Jan 19, 2007, at 11:03 AM, johnf wrote: > >> From what I understand the use schema is to separate users use of >> tables. IOW >> just added security. But like I said I have never used schemas - >> but a >> public one. So please add to the discussion. > > The most common use for schemas that I have seen is to logically > compartmentalize data. Example: keeping a separate schema for each > fiscal year, making it easy to work with years individually, or > occasionally to select across years. Likewise for a company that has > several divisions; each division gets its own schema, so that they > can work independently, but queries can be run by the main office > that combine schemas. > > I don't quite get why schemas are necessary; I don't understand why > you can't just use separate databases.
My take is a schema is like a collection of server side views. but maybe with a different syntax that makes something else better. still learning.... Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
