how to off sql server owner name that dbo?

whenever we expand the t开发者_JAVA百科able list from sql server 2005 then table name shows with owner name. is there anyway out to off the owner name as a result only table name will display in sql server 2005.

thanks

First, it's not the owner. It's the schema. Since the 2005 version came out, these are distinct concepts.

Second, no, I do not believe it's possible to prevent the schemas being shown alongside the table names in Management Studio's Object Explorer (presumably, where you're looking). The Object Explorer Details pane does show them in separate columns, so if you just want an alphabetical list of tables without schema names, then you can look/sort the tables there.

Thomas - Open Tools -> Options, and select "SQL Server Object Explorer" in the left hand pane. This is the only obvious place where such an option would exist, and it does not exist

You can use schema Filter Tables->LeftClick->Filter