Yes, I was going to echo this. In terms of MySQL, I think of the schema as the collection of DDL (data definition language) statements that make up your database. Table structure, column types etc.
The schema, together with the actual data make up a database. Cheers, Jared. -----Original Message----- From: Jason Martin [mailto:[EMAIL PROTECTED] Sent: 03 August 2005 15:33 To: mysql@lists.mysql.com Subject: Re: What is a schema? On Wed, Aug 03, 2005 at 03:30:19PM +0100, Juan Pedro Reyes Molina wrote: > as far as I know a schema is a description of a database. In ORACLE terms, a schema is a grouping of database objects (tables, indexes, and so on). It is synonymous with user in ORACLE. A given ORACLE instance can contain multiple schemas. -Jason Martin -- I'd love to, but I have to rotate my crops. This message is PGP/MIME signed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
