Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2007-11-23 : 10:11:22
|
| Good afternooncould someone tell what is a schema is when using within SQL SERVER 2005Many thanksRob |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-23 : 10:14:26
|
| well if you're familiar with .net a schema is analogous to a namespace.it's an owner of objects_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-11-23 : 11:35:39
|
quote:
Originally posted by spirit1
well if you're familiar with .net a schema is analogous to a namespace.it's an owner of objects
Oooooh... I don't think you want to be calling it an "owner" of objects. Conceptually that's right, but given the history of SQL Server object owners and the fact that now in SQL Server 2005 you have schemas and owners - you definitely don't want to be calling a schema an "owner of objects". |
|
|
|
|
|
|
what is a schema