Utility SPs
Jump to navigation
Jump to search
Utility SPs provide low level functionality across all implementations.
- util_add_audit_detail
- util_add_audit_event
- util_add_basic_workflow
- util_add_column
- util_add_column_view_meta
- util_add_core_workflow
- util_add_mapping_set
- util_add_mapping_value
- util_add_mig_script
- util_add_sp_workflow
- util_adjust_lookup_sql
- util_analyse_indexes
- util_bdi_add_import
- util_bdi_clone_import
- util_bulk_add_timesheets
- util_calc_depency_order
- util_check_delegation
- util_check_messages
- util_check_table_usage
- util_clone_record
- util_close_file
- util_cols_from_dynamic_sql
- util_cols_to_text
- util_compare_column
- util_compare_metadata
- util_compare_objects
- util_compare_table
- util_compare_tables
- util_compare_varchar_max
- util_config_docs
- util_config_new_form
- util_config_set_all_fk_lookups
- util_config_wasp_summary
- util_configure_doc_purposes
- util_create_asset_view
- util_create_asset_views
- util_create_child_asset_views
- util_create_ems_lookups
- util_create_fk_lookup
- util_create_form_fields
- util_create_index_stats
- util_create_insert_batch
- util_create_job
- util_create_job_step
- util_create_new_asset_view
- util_create_ri_views
- util_create_table_metadata_from_SP
- util_create_table_v4_view
- util_create_table_view
- util_create_table_view_cursor
- util_create_table_view2
- util_create_tran_header_lines
- util_create_view
- util_create_W4_view
- util_create_W4_view2
- util_crt_lookup
- util_csv_to_asset_sql
- util_csv_to_hierarchy_sql
- util_defrag_all_indexes
- util_delete_all_assets
- util_delete_all_utilities
- util_delete_column
- util_delete_column_meta
- util_delete_column_phys
- util_delete_column_view_meta
- util_delete_empty_hierarchy
- util_delete_invalid_saved_searches
- util_delete_mapping_set
- util_delete_ri
- util_delete_table
- util_delete_table_meta
- util_delete_table_metadata_leaving_security
- util_delete_table_phys
- util_describe
- util_doc_gen_columns
- util_dump_sql
- util_dump_table_sql
- util_dup_frames_field_pos
- util_dup_hierarchy
- util_dup_layout
- util_dup_layout_2
- util_dup_metadata
- util_dup_metadata_diff
- util_ems_guid_for_table_column
- util_ems_guids_for_table_column
- util_execute_file
- util_execute_file_2k
- util_execute_file_2k5
- util_fetch_lookup_text
- util_find_overlaps
- util_fix_asset_view
- util_fix_case
- util_fix_form_layout
- util_fix_grid_col_order
- util_fix_tabbing_order
- util_generate_bulk_guids
- util_generate_routine_script
- util_generate_table_script
- util_generate_temp_object_script
- util_generate_temp_object_script_2k
- util_generate_temp_object_script_2k5
- util_get_and_log_seq_number
- util_get_and_log_w4_number
- util_get_col_list
- util_get_cols_from_sql_or_lookup
- util_get_default_value
- util_get_env_var
- util_get_lookup_data
- util_get_sql_column_name
- util_get_sql_column_name_ex
- util_get_table_primary_keys
- util_get_win_temp_basix_dir
- util_import_lookup_data
- util_import_table
- util_is_valid_ems_id
- util_layout_form
- util_list_missing_lookups
- util_log_identity
- util_merge_workflow
- util_mig_run_migration_scripts
- util_move_fields
- util_move_fields_on_tab
- util_move_literal_to_ems_lookups
- util_move_table_to_ems_lookups
- util_notifier_add_event
- util_notifier_clone_event
- util_notifier_remove_event
- util_open_email
- util_open_file
- util_open_file_read
- util_partition_add
- util_partition_merge
- util_partition_remove_files_groups
- util_patch_apply
- util_patch_check
- util_patch_object
- util_patch_update
- util_pivot_data
- util_post_patch_fixup
- util_prepare_empty_database
- util_print_varchar_max
- util_print_workflow_scripts
- util_query_to_spreadsheet
- util_queue_message
- util_read_file_into_varchar_max
- util_read_line
- util_recurse_relations
- util_refresh_relations
- util_refresh_view
- util_register_workflow
- util_remove_metadata
- util_remove_tmp_table_views
- util_rename_column
- util_rename_column_charts
- util_rename_column_metadata_only
- util_rename_column_schedules
- util_rename_db_logical_name
- util_rename_lookup
- util_rename_table
- util_rename_table_charts
- util_rename_table_schedules
- util_rename_user
- util_renumber_detail_groups
- util_replace_text_column
- util_repoint_view_tables
- util_repoint_views
- util_report_form_data
- util_reset_db
- util_reset_db_securables
- util_reset_seq_generators
- util_reset_url_paths
- util_run_file
- util_run_integrity_checks
- util_scan_all_databases
- util_script_exec_code
- util_script_form_meta
- util_script_index
- util_script_inserts
- util_script_mig_data
- util_search_table_values
- util_secure_fields
- util_secure_form
- util_send_email
- util_send_mail
- util_set_db_constraints
- util_set_decimal_defaults
- util_set_job
- util_set_lookups_W4_view
- util_set_lookups_W4_view2
- util_set_ri
- util_set_workflow_event
- util_sp_diff_db_with_db
- util_sp_diff_file_with_db
- util_sp_diff_varchar_max
- util_space_fields
- util_sql_has_rows
- util_switch_db
- util_table_data_row
- util_timed_actions
- util_tmp_script_table
- util_update_temp_syscomments_entry
- util_w4_change_view_db_definition
- util_w4_change_view_db_definition_2k
- util_w4_change_view_db_definition_2k5
- util_w4_change_views_db_definition
- util_write
- util_write_email_line
- util_write_file_from_varchar_max
- util_write_line
- util_write_log_entry
- util_write_xml_field
- util_write_xml_text