Enumeración DBCOMMANDOPENUM (cmdtree.h)

El DBCOMMANDOPENUM tipo enumerado contiene una lista de los posibles operadores de comando para los nodos de un árbol de comandos.

Sintaxis

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
} ;

Constantes

Observaciones

El proveedor OLE DB para el servicio de indexación no admite todos los operadores de este tipo enumerado. Indexing Service solo admite elementos de la lista designada por el comentario "// Indexing Service".

Para obtener información sobre los operadores individuales, consulte Operadores de manipulación de datos.

Requisitos