Object type filter

DBA xPress ›› Features ›› Object Browser ›› Match Elements ››
Parent Previous Next

Object Type Filter


The object type filter has two properties, 'Mode' and 'Type'. The 'Type' is simply the type of object, i.e. 'Table', 'Column', 'View' etc.


The 'Mode' specifies how the object type match is applied 

Mode

Description

is

Specifies that the object will match if it's type is the same as the selected type

is not

Specifies that the object will match if it's type is not the same as the selected type

is not and is not parented by

Specifies that the object will match if it's type is the same as the selected type, and the object is not parented by the selected type

is not parented by

Specifies that the object will match if it is not parented by the selected type

is or is parented by

Specifies that the object will match if it's type is the same as the selected type, or it is parented by the selected type

is parented by

Specifies that the object will match if it is parented by the selected type

 

The parenting rules are as follows 

Parent Object Type

Child Object Types

Table

Column

Primary Key Constraint

Check Constraint

Unique Constraint

Default Constraint

Foreign Key Constraint

Relational Index

XML Index

Spatial Index

Statistics Collection

Assembly DML Trigger

DML Trigger

Default

Type Default Binding

Column Default Binding

Rule

Type Rule Binding

Column Rule Binding

View

Relational Index

XML Index

Spatial Index

Statistics Collection

Assembly DML Trigger

DML Trigger

Assembly

Assembly Stored Procedure

Aggregate Function

Assembly Scalar Function

Assembly Table Function

Assembly DML Trigger

Assembly DDL Trigger

Assembly Type

Partition Function

Partition Scheme

Full Text Catalog

Full Text Index

Full Text Index

Full Text Stop List

Service Queue

Service

Event Notification

Service Contract

Service

Column

Check Constraint

Default Constraint

File group

Table

Relational Index

XML Index

Spatial Index

Full Text Catalog

Schema

Table

Synonym

Default

Rule

Primary Key Constraint

Check Constraint

Unique Constraint

Default Constraint

Foreign Key Constraint

Assembly Stored Procedure

Aggregate Function

Assembly Scalar Function

Assembly Table Function

Assembly DML Trigger

Stored Procedure

Replication Filter Procedure

View

Scalar Function

Inline Table Function

Table Function

DML Trigger

Assembly Type

XML Schema Collection

User Defined Type