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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 how to remove the dbo in front of tables

Author  Topic 

corylocke
Starting Member

1 Post

Posted - 2012-10-26 : 08:06:26
in Management Studio 2008, how do you not display the object or owner name in front of the table.

ex. you open a database under object explorer and then navigate to table it displays dbo.tablename

how can I only display the Tablename without the .dbo (or table owner)?

thanks in Advance

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-10-26 : 08:21:01
As far as I know, there is no option or switch that would turn off the scheman name in the tables section of the object explorer tree.
Go to Top of Page
   

- Advertisement -