DBCOMMANDOPENUM Enumeration

[Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.]

The DBCOMMANDOPENUM enumerated type contains a list of the possible command operators for nodes in a command tree.

Syntax

typedef enum DBCOMMANDOPENUM {
  DBOP_scalar_constant,
  DBOP_DEFAULT,
  DBOP_NULL,
  DBOP_bookmark_name,
  DBOP_catalog_name,
  DBOP_column_name,
  DBOP_schema_name,
  DBOP_outall_name,
  DBOP_qualifier_name,
  DBOP_qualified_column_name,
  DBOP_table_name,
  DBOP_nested_table_name,
  DBOP_nested_column_name,
  DBOP_row,
  DBOP_table,
  DBOP_sort,
  DBOP_distinct,
  DBOP_distinct_order_preserving,
  DBOP_alias,
  DBOP_cross_join,
  DBOP_union_join,
  DBOP_inner_join,
  DBOP_left_semi_join,
  DBOP_right_semi_join,
  DBOP_left_anti_semi_join,
  DBOP_right_anti_semi_join,
  DBOP_left_outer_join,
  DBOP_right_outer_join,
  DBOP_full_outer_join,
  DBOP_natural_join,
  DBOP_natural_left_outer_join,
  DBOP_natural_right_outer_join,
  DBOP_natural_full_outer_join,
  DBOP_set_intersection,
  DBOP_set_union,
  DBOP_set_left_difference,
  DBOP_set_right_difference,
  DBOP_set_anti_difference,
  DBOP_bag_intersection,
  DBOP_bag_union,
  DBOP_bag_left_difference,
  DBOP_bag_right_difference,
  DBOP_bag_anti_difference,
  DBOP_division,
  DBOP_relative_sampling,
  DBOP_absolute_sampling,
  DBOP_transitive_closure,
  DBOP_recursive_union,
  DBOP_aggregate,
  DBOP_remote_table,
  DBOP_select,
  DBOP_order_preserving_select,
  DBOP_project,
  DBOP_project_order_preserving,
  DBOP_top,
  DBOP_top_percent,
  DBOP_top_plus_ties,
  DBOP_top_percent_plus_ties,
  DBOP_rank,
  DBOP_rank_ties_equally,
  DBOP_rank_ties_equally_and_skip,
  DBOP_navigate,
  DBOP_nesting,
  DBOP_unnesting,
  DBOP_nested_apply,
  DBOP_cross_tab,
  DBOP_is_NULL,
  DBOP_is_NOT_NULL,
  DBOP_equal,
  DBOP_not_equal,
  DBOP_less,
  DBOP_less_equal,
  DBOP_greater,
  DBOP_greater_equal,
  DBOP_equal_all,
  DBOP_not_equal_all,
  DBOP_less_all,
  DBOP_less_equal_all,
  DBOP_greater_all,
  DBOP_greater_equal_all,
  DBOP_equal_any,
  DBOP_not_equal_any,
  DBOP_less_any,
  DBOP_less_equal_any,
  DBOP_greater_any,
  DBOP_greater_equal_any,
  DBOP_anybits,
  DBOP_allbits,
  DBOP_anybits_any,
  DBOP_allbits_any,
  DBOP_anybits_all,
  DBOP_allbits_all,
  DBOP_between,
  DBOP_between_unordered,
  DBOP_match,
  DBOP_match_unique,
  DBOP_match_partial,
  DBOP_match_partial_unique,
  DBOP_match_full,
  DBOP_match_full_unique,
  DBOP_scalar_parameter,
  DBOP_scalar_function,
  DBOP_plus,
  DBOP_minus,
  DBOP_times,
  DBOP_over,
  DBOP_div,
  DBOP_modulo,
  DBOP_power,
  DBOP_like,
  DBOP_sounds_like,
  DBOP_like_any,
  DBOP_like_all,
  DBOP_is_INVALID,
  DBOP_is_TRUE,
  DBOP_is_FALSE,
  DBOP_and,
  DBOP_or,
  DBOP_xor,
  DBOP_equivalent,
  DBOP_not,
  DBOP_implies,
  DBOP_overlaps,
  DBOP_case_condition,
  DBOP_case_value,
  DBOP_nullif,
  DBOP_cast,
  DBOP_coalesce,
  DBOP_position,
  DBOP_extract,
  DBOP_char_length,
  DBOP_octet_length,
  DBOP_bit_length,
  DBOP_substring,
  DBOP_upper,
  DBOP_lower,
  DBOP_trim,
  DBOP_translate,
  DBOP_convert,
  DBOP_string_concat,
  DBOP_current_date,
  DBOP_current_time,
  DBOP_current_timestamp,
  DBOP_content_select,
  DBOP_content,
  DBOP_content_freetext,
  DBOP_content_proximity,
  DBOP_content_vector_or,
  DBOP_delete,
  DBOP_update,
  DBOP_insert,
  DBOP_min,
  DBOP_max,
  DBOP_count,
  DBOP_sum,
  DBOP_avg,
  DBOP_any_sample,
  DBOP_stddev,
  DBOP_stddev_pop,
  DBOP_var,
  DBOP_var_pop,
  DBOP_first,
  DBOP_last,
  DBOP_in,
  DBOP_exists,
  DBOP_unique,
  DBOP_subset,
  DBOP_proper_subset,
  DBOP_superset,
  DBOP_proper_superset,
  DBOP_disjoint,
  DBOP_pass_through,
  DBOP_defined_by_GUID,
  DBOP_text_command,
  DBOP_SQL_select,
  DBOP_prior_command_tree,
  DBOP_add_columns,
  DBOP_column_list_anchor,
  DBOP_column_list_element,
  DBOP_command_list_anchor,
  DBOP_command_list_element,
  DBOP_from_list_anchor,
  DBOP_from_list_element,
  DBOP_project_list_anchor,
  DBOP_project_list_element,
  DBOP_row_list_anchor,
  DBOP_row_list_element,
  DBOP_scalar_list_anchor,
  DBOP_scalar_list_element,
  DBOP_set_list_anchor,
  DBOP_set_list_element,
  DBOP_sort_list_anchor,
  DBOP_sort_list_element,
  DBOP_alter_character_set,
  DBOP_alter_collation,
  DBOP_alter_domain,
  DBOP_alter_index,
  DBOP_alter_procedure,
  DBOP_alter_schema,
  DBOP_alter_table,
  DBOP_alter_trigger,
  DBOP_alter_view,
  DBOP_coldef_list_anchor,
  DBOP_coldef_list_element,
  DBOP_create_assertion,
  DBOP_create_character_set,
  DBOP_create_collation,
  DBOP_create_domain,
  DBOP_create_index,
  DBOP_create_procedure,
  DBOP_create_schema,
  DBOP_create_synonym,
  DBOP_create_table,
  DBOP_create_temporary_table,
  DBOP_create_translation,
  DBOP_create_trigger,
  DBOP_create_view,
  DBOP_drop_assertion,
  DBOP_drop_character_set,
  DBOP_drop_collation,
  DBOP_drop_domain,
  DBOP_drop_index,
  DBOP_drop_procedure,
  DBOP_drop_schema,
  DBOP_drop_synonym,
  DBOP_drop_table,
  DBOP_drop_translation,
  DBOP_drop_trigger,
  DBOP_drop_view,
  DBOP_foreign_key,
  DBOP_grant_privileges,
  DBOP_index_list_anchor,
  DBOP_index_list_element,
  DBOP_primary_key,
  DBOP_property_list_anchor,
  DBOP_property_list_element,
  DBOP_referenced_table,
  DBOP_rename_object,
  DBOP_revoke_privileges,
  DBOP_schema_authorization,
  DBOP_unique_key,
  DBOP_scope_list_anchor,
  DBOP_scope_list_element,
  DBOP_content_table
} ;

Constants

DBOP_scalar_constant
DBOP_DEFAULT
DBOP_NULL
DBOP_bookmark_name
DBOP_catalog_name
DBOP_column_name
DBOP_schema_name
DBOP_outall_name
DBOP_qualifier_name
DBOP_qualified_column_name
DBOP_table_name
DBOP_nested_table_name
DBOP_nested_column_name
DBOP_row
DBOP_table
DBOP_sort
DBOP_distinct
DBOP_distinct_order_preserving
DBOP_alias
DBOP_cross_join
DBOP_union_join
DBOP_inner_join
DBOP_left_semi_join
DBOP_right_semi_join
DBOP_left_anti_semi_join
DBOP_right_anti_semi_join
DBOP_left_outer_join
DBOP_right_outer_join
DBOP_full_outer_join
DBOP_natural_join
DBOP_natural_left_outer_join
DBOP_natural_right_outer_join
DBOP_natural_full_outer_join
DBOP_set_intersection
DBOP_set_union
DBOP_set_left_difference
DBOP_set_right_difference
DBOP_set_anti_difference
DBOP_bag_intersection
DBOP_bag_union
DBOP_bag_left_difference
DBOP_bag_right_difference
DBOP_bag_anti_difference
DBOP_division
DBOP_relative_sampling
DBOP_absolute_sampling
DBOP_transitive_closure
DBOP_recursive_union
DBOP_aggregate
DBOP_remote_table
DBOP_select
DBOP_order_preserving_select
DBOP_project
DBOP_project_order_preserving
DBOP_top
DBOP_top_percent
DBOP_top_plus_ties
DBOP_top_percent_plus_ties
DBOP_rank
DBOP_rank_ties_equally
DBOP_rank_ties_equally_and_skip
DBOP_navigate
DBOP_nesting
DBOP_unnesting
DBOP_nested_apply
DBOP_cross_tab
DBOP_is_NULL
DBOP_is_NOT_NULL
DBOP_equal
DBOP_not_equal
DBOP_less
DBOP_less_equal
DBOP_greater
DBOP_greater_equal
DBOP_equal_all
DBOP_not_equal_all
DBOP_less_all
DBOP_less_equal_all
DBOP_greater_all
DBOP_greater_equal_all
DBOP_equal_any
DBOP_not_equal_any
DBOP_less_any
DBOP_less_equal_any
DBOP_greater_any
DBOP_greater_equal_any
DBOP_anybits
DBOP_allbits
DBOP_anybits_any
DBOP_allbits_any
DBOP_anybits_all
DBOP_allbits_all
DBOP_between
DBOP_between_unordered
DBOP_match
DBOP_match_unique
DBOP_match_partial
DBOP_match_partial_unique
DBOP_match_full
DBOP_match_full_unique
DBOP_scalar_parameter
DBOP_scalar_function
DBOP_plus
DBOP_minus
DBOP_times
DBOP_over
DBOP_div
DBOP_modulo
DBOP_power
DBOP_like
DBOP_sounds_like
DBOP_like_any
DBOP_like_all
DBOP_is_INVALID
DBOP_is_TRUE
DBOP_is_FALSE
DBOP_and
DBOP_or
DBOP_xor
DBOP_equivalent
DBOP_not
DBOP_implies
DBOP_overlaps
DBOP_case_condition
DBOP_case_value
DBOP_nullif
DBOP_cast
DBOP_coalesce
DBOP_position
DBOP_extract
DBOP_char_length
DBOP_octet_length
DBOP_bit_length
DBOP_substring
DBOP_upper
DBOP_lower
DBOP_trim
DBOP_translate
DBOP_convert
DBOP_string_concat
DBOP_current_date
DBOP_current_time
DBOP_current_timestamp
DBOP_content_select
DBOP_content
DBOP_content_freetext
DBOP_content_proximity
DBOP_content_vector_or
DBOP_delete
DBOP_update
DBOP_insert
DBOP_min
DBOP_max
DBOP_count
DBOP_sum
DBOP_avg
DBOP_any_sample
DBOP_stddev
DBOP_stddev_pop
DBOP_var
DBOP_var_pop
DBOP_first
DBOP_last
DBOP_in
DBOP_exists
DBOP_unique
DBOP_subset
DBOP_proper_subset
DBOP_superset
DBOP_proper_superset
DBOP_disjoint
DBOP_pass_through
DBOP_defined_by_GUID
DBOP_text_command
DBOP_SQL_select
DBOP_prior_command_tree
DBOP_add_columns
DBOP_column_list_anchor
DBOP_column_list_element
DBOP_command_list_anchor
DBOP_command_list_element
DBOP_from_list_anchor
DBOP_from_list_element
DBOP_project_list_anchor
DBOP_project_list_element
DBOP_row_list_anchor
DBOP_row_list_element
DBOP_scalar_list_anchor
DBOP_scalar_list_element
DBOP_set_list_anchor
DBOP_set_list_element
DBOP_sort_list_anchor
DBOP_sort_list_element
DBOP_alter_character_set
DBOP_alter_collation
DBOP_alter_domain
DBOP_alter_index
DBOP_alter_procedure
DBOP_alter_schema
DBOP_alter_table
DBOP_alter_trigger
DBOP_alter_view
DBOP_coldef_list_anchor
DBOP_coldef_list_element
DBOP_create_assertion
DBOP_create_character_set
DBOP_create_collation
DBOP_create_domain
DBOP_create_index
DBOP_create_procedure
DBOP_create_schema
DBOP_create_synonym
DBOP_create_table
DBOP_create_temporary_table
DBOP_create_translation
DBOP_create_trigger
DBOP_create_view
DBOP_drop_assertion
DBOP_drop_character_set
DBOP_drop_collation
DBOP_drop_domain
DBOP_drop_index
DBOP_drop_procedure
DBOP_drop_schema
DBOP_drop_synonym
DBOP_drop_table
DBOP_drop_translation
DBOP_drop_trigger
DBOP_drop_view
DBOP_foreign_key
DBOP_grant_privileges
DBOP_index_list_anchor
DBOP_index_list_element
DBOP_primary_key
DBOP_property_list_anchor
DBOP_property_list_element
DBOP_referenced_table
DBOP_rename_object
DBOP_revoke_privileges
DBOP_schema_authorization
DBOP_unique_key
DBOP_scope_list_anchor
DBOP_scope_list_element
DBOP_content_table

Remarks

The OLE DB Provider for Indexing Service does not support all the operators in this enumerated type. Indexing Service supports only elements in the list designated by the comment "// Indexing Service".

For information about individual operators, see Data Manipulation Operators.

Requirements

   
Minimum supported client Windows 2000 Professional [desktop apps only]
Minimum supported server Windows 2000 Server [desktop apps only]
Header cmdtree.h