Yes, you are exactly right. The schema is the structure of the database. Keith
> I've been referencing a variety of sources, including wikipedia. What I > know about a schema is that in SQLite the .schema command will show the > the SQL structure of that databases tables, which would be analogous to > "DESCRIBE foo" in MySQL (with the difference that SQLite shows all tables > in one go). > > The schema is the structure of the database? > > I'm trying to understand what the wikipedia article is driving at. I > would assume that only tables which are related go in the same database? > That would my instinct, at least. Tables which are unrelated going into > a different database. > > The quote from wikipedia: > > The problem that arises is that former MySQL users will mistakenly create > multiple databases for one project. In this context MySQL databases are > analogous in function to Postgres-schemas, insomuch as Postgres lacks off- > the-shelf cross-database functionality that MySQL has. Conversely, > Postgres has rightfully applied more of the specification, in a sane- > bottom-up approach, implementing cross-table, cross-schema, and then left > room for future cross-database functionality. > > http://en.wikipedia.org/wiki/ > Comparison_of_relational_database_management_systems#Databases_vs_Schemas_.28terminology.29 > > > thanks, > > Thufir > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
