Geeks With Blogs
A Curious Mind #tastic

Woot! I just found out about SQL Schemas. If you don't know SQL schemas are like namespaces in .Net code. So now I can organize my SQL tables into groups which should make life a whole lot easier. Now SQL Schema are not as fine grained as namespaces, and you could do this in 2000 it just wasn't as nice as it is now.

dbo.product
\_/ \_____/
 |      |-table name
 |
 |- schema name

Now we can do things like security.user or logging.error without polluting the default dbo where we can keep just our app code. Now if we can just get vendors to hop on this wagon, it would be easier to mix apps inside one database instead of a whole bunch of databases.

As an added bonus NHibernate supports schemas right now.

Posted on Monday, July 3, 2006 4:51 PM | Back to top


Comments on this post: SQL 2005 Schemas Rock

# re: SQL 2005 Schemas Rock
Requesting Gravatar...
i want SQL Schemas...
like humanresources etc
mail me
Left by tarun sanchihar on Nov 19, 2008 4:26 PM

Your comment:
 (will show your gravatar)


Copyright © Dru Sellers | Powered by: GeeksWithBlogs.net