On Friday 19 January 2007 10:47, Carl Karsten wrote: > Ed Leafe wrote: > > On Jan 19, 2007, at 1:15 PM, Carl Karsten wrote: > >> 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.... > > > > Nope. The tables in schema A are completely distinct from tables in > > schema B. No different than if they were tables in two databases. > > Then what is the difference between a schema and a database? > > > Carl K > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Database --> schema --> tables. Therefore a Database can have many schemas. And each schema can have many tables. Within a schema a tablename must be unique but within a database you can have dup tableNames - because of schema.tablename. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
