http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to MYSQL doc: A schema is a database
Wikopedia says a Schema is defined as: Pronounced as skee-ma, the structure of a database system, described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables.Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.[1] and further categorised to: Conceptual Schema: A Map of concepts and their relationships Logical Schema a map of entities and their attributes and relations Physical Schema an implementation of a logical schema Schema Object such as oracle DB Object M-- ----- Original Message ----- From: "Thufir" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Sunday, March 02, 2008 3:46 AM Subject: what is a schema? what is a database? > 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_.2 8terminology.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]
