注意
从 Windows XP 开始，索引服务不再受支持，并且自Windows 8起无法使用。 请改用 Windows 搜索 进行客户端搜索，使用 Microsoft Search Server Express 进行服务器端搜索。
DBCOMMANDOPENUM 枚举类型包含命令树中节点的可能命令运算符列表。
语法
typedef enum DBCOMMANDOPENUM {
DBOP_scalar_constant = 0,
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
} ;
常量
DBOP_scalar_constant值： 0 |
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 |
注解
用于索引服务的 OLE DB 提供程序不支持此枚举类型中的所有运算符。 索引服务仅支持注释“//索引服务”指定的列表中的元素。
有关单个运算符的信息，请参阅 数据操作运算符。
要求
| 要求 | 值 |
|---|---|
| 最低受支持的客户端 | Windows 2000 Professional [仅限桌面应用] |
| 最低受支持的服务器 | Windows 2000 Server [仅限桌面应用] |
| 标头 | cmdtree.h |