SQL Server Management Studio Schema View

views:

477

answers:

+3 Q:

SQL Server Management Studio Schema View

I'm working with a SQL server and several databases. Each database may have many schema's, such as dbo., admin., other., and I'm getting tired of scrolling around trying to find things.

If I'm working on a schema specific project, I want to filter out everything else from my view except that schema. As dbo, I see everything which means I spend the majority of my day molesting my scroll wheel (that is a joke).

Is this possible in SQL Server Management Studio 2008?

+1 A:

Yes: don't connect as db_owner or "sa".

Connect as a user that can access and change the desired schema only.

This way, the engine "Metadata visibility" will do it automatically

gbn 2010-02-25 20:04:58

Can I do it without changing who I connect as?

Coov 2010-02-25 20:12:09

@Coov: If you change your rights. The engine returns objects you're allowed to see... so whether a different user or different rights acheives the same result

gbn 2010-02-25 20:15:47

+3 A:

In SSMS 2005 or 2008, right click on the heading: "Stored Procedures", "Tables", etc, then on "Filter Settings", then for the "Schema" change "Operator" to "Does not contain" or "Contains", etc and then set a Value to filter them...

KM 2010-02-25 21:28:06

Awesome! I never knew about the filter. The only filter that works is "Creation Date". Name, Schema, and Owner don't let me apply a filter. Perhaps a bug. Regardless, +1 for the filter!

Coov 2010-02-26 15:34:43

Ok this is funny. I have to paste the value into the filter. Typing into the filter does nothing.

Coov 2010-02-26 15:35:48

ansaurus

tags:

views:

answers:

SQL Server Management Studio Schema View

related questions