Posted by Erland Sommarskog on 08/30/05 00:07

(wackyphill@yahoo.com) writes:
> OK, so schema is roughly like a Group in Windows and Tables are
> somewhat like Users?
>
> I think I get it. Thanks for the help.

Given the confusion with users and schema in SQL 2000, this is maybe
not the best analogy. Serge's comparison with a file system was a good
one, and I offer a very similar, but real one: schema is the drive,
and the table is a path on that drive.

(Although on SQL 2005 you cannot really change your current schema like
you change directory in a file system.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]