Filter objects on extended properties?

debry · April 29, 2019 11:13PM

In the custom filter rules, it appears that the only filter options are on name or schema. Is it possible to filter on other properties, specifically the extended properties?

Eddie D · May 1, 2019 8:38AM

Hi debry, thank you for your forum post.

You can create a custom filter for Extended properties, steps as follows:

1. Click the 'custom filter rules' link.
2. Edit filter rules dialog appears.
3. Change the For: drop down box from 'All object types in all schemas' to 'Extended property', as per the screen shot below:

Image: https://us.v-cdn.net/6029854/uploads/editor/6a/eporuldfd6l1.jpg

4. Modify the other parameters as required, Include If or Exclude If, Object Name, Operator and value as required.

Many Thanks
Eddie

debry · May 1, 2019 4:34PM

Thanks Eddie. Sorry, I didn't mean the extended properties in isolation. What I meant to ask is there a way to filter on objects (for example, tables) based on the extended properties associated with them?

Eddie D · May 9, 2019 3:03PM

Hi Debry, thank you for your reply.

Sorry for the confusion. Sadly you cannot filter on an object based on the extended properties associated with it. If this is a feature you would like to see in a future version of SQL Compare, I recommend that vote and comment on this Redgate UserVoice Forum.

The UserVoice forum is the best place for feature suggestions.

Many Thanks
Eddie

Filter objects on extended properties?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk