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]
