Start a new topic

Schema filter works incorrectly if contains several conditions

anonymous

started a topic over 11 years ago

[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

Roger Bjärevall

said over 11 years ago

[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

How can we help you today?

Schema filter works incorrectly if contains several conditions

anonymous

Roger Bjärevall