SQL Server Management Studio Schema View SQL Server Management Studio Schema View sql-server sql-server

SQL Server Management Studio Schema View


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...


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


FYI, I was searching for tables under cdc schema, the change data capture schema that was created. After much struggle, I found that those tables are in the Tables->System Tables folder. So SSMS did show the non default schema but in this case it was in a different folder.