Count

The Count function takes one relationship name parameter and returns the number of objects of the relationship. The relationship can be a profile relationship or a custom relationship. For example, count('Tables') returns the number of tables of a schema and count('Defines') returns the number of objects a term defines.

The count function can appear in the SELECT list or be used along with the following operators as a filter in the WHERE clause: =, !=, = ANY (...), != ANY (...), <, <=, >, >=, EXISTS and NOT EXISTS.