Start a new topic

Schema filter works incorrectly if contains several conditions

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I use DbVisualizer v9.06 with SQL Server 2005 SP2 using bundled jTDS JDBC driver (v1.2.7). I specify schema filter for Views to exclude "+sys+" and "+INFORMATION_SCHEMA+" views using two "*<>*" conditions with match "*All*" (see attached picture). Such filter then excludes all views (like those in "+dbo+" or other schemas). Filter with only one condition works correctly. Edited by: abyss on 2013-05-08 11.20 Edited by: abyss on 2013-05-08 11.21
1 Comment

[This reply is migrated from our old forums.]
[Attachment has been removed.]

Re: Schema filter works incorrectly if contains several conditions
Abyss, To skip both sys and information_schema set the Schema (sys|information_schema) and Name = * by using Match All. See screenshot. I hope this helps. Regards Roger