Sorry. An example of a fully qualified SQL Server object name is: SELECT * FROM Server123.Database456.Sales.Product
The object Server123.Database456.Manufacture.Product is a different table from Server123.Database456.Sales.Product. Joerg Bruehe in his post called a "schema" a "namespace", I believe he is correct. -----Original Message----- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Thufir Sent: Wednesday, March 05, 2008 3:09 AM To: mysql@lists.mysql.com Subject: Re: FW: Re: what is a schema? what is a database? On Tue, 04 Mar 2008 07:21:21 -0800, Garris, Nicole wrote: > My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every > DBMS is different in this regard. Microsoft's SQL Server works like > this: > > A SQL Server instance ("server") can have many databases. > > A database can have many schemas, schema simply being a grouping for > objects in a database. In a SQL Server 2005 database, there can be two > tables named "Product" if one is in the schema Sales and the other is > in the schema Manufacture. The two tables are Sales.Product and > Manufacture.Product. > > A fully qualified SQL Server object name is > server.database.schema.object. In your two examples: SELECT * FROM server.sales.schema.product; SELECT * FROM server.product.schema.product; I'm a bit tired, so maybe I'm not seeing it, but what goes in the schema place holder? -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]
