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 |
|
RB2K
Starting Member
4 Posts |
 Posted - 2008-03-26 : 11:23:16
|
In SQL Server Management Studio when browsing the tables they are all prefixed with dbo followed by the table name. Is there a way of turning this off.Thanks  |
|
|
PABluesMan
Starting Member
26 Posts |
Posted - 2008-03-26 : 11:26:25
|
| No there is not, nor would you want to. This is the schema to which the object belongs; it is VERY important.Refer to the SQL Books Online for more information on schemas and object ownership.Hope this helps!I geek, therefore I am |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-03-26 : 11:28:00
|
| The dbo prefix is the schemes that the table belongs to. I am only new myself, but user can create other schemes. I not quite sure the exact definition of a scheme, but i do know that it is a collection of objects, ie Tables. |
|
|
|
RB2K
Starting Member
4 Posts |
Posted - 2008-03-26 : 13:20:22
|
| Thanks for the update. I do see the importance of the owners of objects but its painful when you just want to search for the table by clicking on one and then typing in the name and watching it traverse down the tree. It would be so useful. |
|
|
|
|
|
|
SQL DBO Table Names