Vorheriges Thema: Tabellen- und ObjektquerverweiseNächstes Thema: SQL-Name zu Tabelle und Objekt


Tabelle zu SQL-Name und Objekt

Diese Tabelle bietet einen Querverweis von jeder Tabelle im Datenbankschema auf die entsprechenden SQL- und Objektnamen:

Tabelle

SQL-Name (AKA)

Objekt

Access_Levels

acc_lvls

acc_lvls

Access_Type_v2

acctyp_v2

acctyp

Act_Log

act_log

alg

Act_Type

act_type

aty

Act_Type_Assoc

atyp_asc

act_type_assoc

Active_Boolean_Table

actbool

actbool

Active_Reverse_Boolean_Table

actrbool

actrbool

admin_tree

admin_tree

ADMIN_TREE

Am_Asset_Map

am_map

am_asset_map

Animator

anima

ANI

Archive_Purge_History

arcpur_hist

arcpur_hist

Archive_Purge_Rule

arcpur_rule

arcpur_rule

Asset_Assignment

hier

hier

Atomic_Condition

atomic_cond

atomic_cond

Attached_Events

att_evt

atev

Attached_SLA

attached_sla

attached_sla

Anhang

attmnt

attmnt

attmnt_folder

attmnt_folder

attmnt_folder

Attribute_Name

atn

 

Audit_Log

audit_log

audlog

Behavior_Template

bhvtpl

bhvtpl

Boolean_Table

bool_tab

bool

Bop_Workshift

bpwshft

wrkshft

BU_TRANS

BU_TRANS

BU_TRANS

Business_Management

busmgt

bmhier

Business_Management_Class

buscls

bmcls

Business_Management_Repository

busrep

bmrep

Business_Management_Status

busstat

bms

ca_asset_type

ca_asset_type

 

ca_company

ca_company

ca_cmpny

ca_company_type

ca_company_type

vpt

ca_contact

ca_contact

cnt

ca_contact_type

ca_contact_type

ctp

ca_country

ca_country

country

ca_job_function

ca_job_function

job_func

ca_job_title

ca_job_title

position

ca_location

ca_location

loc

ca_model_def

ca_model_def

mfrmod

ca_organization

ca_organization

org

ca_owned_resource

ca_owned_resource

nr

ca_resource_class

ca_resource_class

grc

ca_resource_cost_center

ca_resource_cost_center

cost_cntr

ca_resource_department

ca_resource_department

dept

ca_resource_family

ca_resource_family

nrf

ca_resource_gl_code

ca_resource_gl_code

gl_code

ca_resource_operating_system

ca_resource_operating_system

opsys

ca_resource_status

ca_resource_status

rss

ca_schema_info

ca_schema_info

 

ca_site

ca_site

Standort

ca_state_province

ca_state_province

state

ca_tenant

ca_tenant

tenant

ca_tenant_group

ca_tenant_group

tenant_group

ca_tenant_group_member

ca_tenant_group_member

tenant_group_member

Call_Req

call_req

cr

Call_Req_Type

crt

crt

Call_Solution

crsol

crsol

Change_Act_Log

chgalg

chgalg

Change_Category

chgcat

chgcat

Change_Request

chg

chg

Change_Status

chgstat

chgstat

Chg_Template

chg_template

chg_tpl

CI_ACTIONS

CI_ACTIONS

CI_ACTIONS

CI_ACTIONS_ALTERNATE

CI_ACTIONS_ALTERNATE

CI_ACTIONS_ALTERNATE

CI_BOOKMARKS

CI_BOOKMARKS

CI_BOOKMARKS

CI_DOC_LINKS

CI_DOC_LINKS

CI_DOC_LINKS

CI_DOC_TEMPLATES

CI_DOC_TEMPLATES

CI_DOC_TEMPLATES

CI_DOC_TYPES

CI_DOC_TYPES

CI_DOC_TYPES

CI_PRIORITIES

CI_PRIORITIES

CI_PRIORITIES

CI_STATUSES

CI_STATUSES

CI_STATUSES

CI_WF_TEMPLATES

CI_WF_TEMPLATES

CI_WF_TEMPLATES

Column_Name

cn

 

Contact_Method

ct_mth

cmth

Controlled_Table

ctab

ctab

Cr_Call_Timers

crctmr

ctimer

Cr_Status

cr_stat

crs

Cr_Stored_Queries

crsq

crsq

Cr_Template

cr_template

cr_tpl

D_PAINTER

D_PAINTER

 

Delegation_Server

dlgtsrv

dlgsrvr

Document_Repository

doc_rep

doc_rep

Domäne

dmn

dmn

Domain_Constraint

dcon

dcon

Domain_Constraint_Type

dcon_typ

dcon_typ

EBR_ACRONYMS

EBR_ACRONYMS

EBR_ACRONYMS

EBR_FULLTEXT

EBR_FULLTEXT

EBR_FULLTEXT

EBR_FULLTEXT_ADM

EBR_FULLTEXT_ADM

EBR_FULLTEXT_ADM

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD

EBR_FULLTEXT_SD_ADM

EBR_FULLTEXT_SD_ADM

EBR_FULLTEXT_SD_ADM

EBR_INDEXING_QUEUE

EBR_INDEXING_QUEUE

EBR_INDEXING_QUEUE

EBR_KEYWORDS

EBR_KEYWORDS

EBR_KEYWORDS

EBR_LOG

EBR_LOG

EBR_LOG

EBR_METRICS

EBR_METRICS

EBR_METRICS

EBR_NOISE_WORDS

EBR_NOISE_WORDS

EBR_NOISE_WORDS

EBR_PATTERNS

EBR_PATTERNS

EBR_PATTERNS

EBR_PREFIXES

EBR_PREFIXES

EBR_PREFIXES

EBR_PROPERTIES

EBR_PROPERTIES

EBR_PROPERTIES

EBR_SUBSTITS

EBR_SUBSTITS

EBR_SUBSTITS

EBR_SUFFIXES

EBR_SUFFIXES

EBR_SUFFIXES

EBR_SYNONYMS

EBR_SYNONYMS

EBR_SYNONYMS

EBR_SYNONYMS_ADM

EBR_SYNONYMS_ADM

EBR_SYNONYMS_ADM

ES_CONSTANTS

ES_CONSTANTS

ES_CONSTANTS

ES_NODES

ES_NODES

ES_NODES

ES_RESPONSES

ES_RESPONSES

ES_RESPONSES

ES_SESSIONS

ES_SESSIONS

ES_SESSIONS

Event_Delay

evt_dly

evtdly

Event_Delay_Type

evtdlytp

evtdlytp

event_log

event_log

event_log

event_type

event_type

event_type

Events

evt

evt

ext_appl

ext_appl

 

External_Entity_Map

xent_map

ext_entity_map

Form_Group

frmgrp

fmgrp

Global_Change_Extension

g_chg_ext

g_chg_ext

Global_Change_Queue

g_chg_queue

g_chg_queue

Global_Contact

g_contact

g_cnt

Global_Issue_Extension

g_iss_ext

g_iss_ext

Global_Issue_Queue

g_iss_queue

g_iss_queue

Global_Location

g_loc

g_loc

Global_Organization

g_org

g_org

Global_Product

g_product

g_prod

Global_Queue_Names

g_queue_names

g_qname

Global_Request_Extension

g_req_ext

g_cr_ext

Global_Request_Queue

g_req_queue

g_cr_queue

Global_Servers

g_srvr

g_srvrs

Global_Table_Map

g_tbl_map

g_tblmap

Global_Table_Rule

g_tbl_rule

g_tblrule

Group_Member

grpmem

grpmem

Impact

impact

imp

INDEX_DOC_LINKS

INDEX_DOC_LINKS

INDEX_DOC_LINKS

Schnittstelle

interface

intfc

Iss_Template

iss_template

iss_tpl

Issue

Issue

Iss

Issue_Act_Log

issalg

issalg

Issue_Category

isscat

isscat

Issue_Property

issprp

iss_prp

Issue_Status

issstat

issstat

Issue_Workflow_Task

isswf

iss_wf

KD_ATTMNT

KD_ATTMNT

KD_ATTMNT

kdlinks

kdlinks

kdlinks

Key_Control

kc

 

Knowledge_Keywords

km_kword

kwrd

KT_REPORT_CARD

KT_REPORT_CARD

KT_REPORT_CARD

LONG_TEXTS

LONG_TEXTS

LONG_TEXTS

Managed_Survey

managed_survey

mgs

Mgs_Act_Log

mgsalg

mgsalg

Mgs_Status

mgsstat

mgsstat

Note_Board

cnote

cnote

NOTIFICATION

NOTIFICATION

NOTIFICATION

Notification_Urgency

noturg

noturg

Notify_Log_Header

not_log

lr

Notify_Object_Attr

ntfl

ntfl

NR_Comment

nr_com

nr_com

O_COMMENTS

O_COMMENTS

O_COMMENTS

O_EVENTS

O_EVENTS

O_EVENTS

O_INDEXES

O_INDEXES

KCAT

Optionen

Optionen

Optionen

P_GROUPS

P_GROUPS

P_GROUPS

Pcat_Loc

pcat_loc

pcat_loc

Person_Contacting

perscon

perscnt

Priorität

pri

pri

Prob_Category

prob_ctg

pcat

Produkt

Produkt

prod

Eigenschaft

prp

prp

Property_Template

prptpl

prptpl

Queued_Notify

not_que

notque

Quick_Template_Types

quick_tpl_types

quick_tpl_types

Remote_Ref

rem_ref

rrf

Reporting_Method

repmeth

rptmeth

Req_Property

cr_prp

cr_prp

Req_Property_Template

cr_prptpl

cr_prptpl

Antwort

response

response

Reverse_Boolean_Table

rbooltab

rev_bool

Rootcause

rootcause

rc

Rpt_Meth

rptmth

rptm

SA_Policy

sapolicy

sapolicy

SA_Prob_Type

saprobtyp

saprobtyp

Sequence_Control

seqctl

seq

Server_Aliases

srvr_aliases

srvr_aliases

Server_Zones

srvr_zones

srvr_zones

Service_Contract

svc_contract

svc_contract

Service_Desc

srv_desc

sdsc

session_log

session_log

session_log

session_type

session_type

session_type

Relevanz

sevrty

sev

SHOW_OBJ

SHOW_OBJ

SHOW_OBJ

SKELETONS

SKELETONS

KD

SLA_Contract_Map

sdsc_map

sdsc_map

SLA_Template

slatpl

slatpl

Spell_Macro

splmac

macro

Spell_Macro_Type

splmactp

macro_type

SQL_Script

sql_tab

 

Survey

Umfrage

Umfrage

Survey_Answer

survey_answer

svy_ans

Survey_Answer_Template

survey_atpl

svy_atpl

Survey_Question

survey_question

svy_ques

Survey_Question_Template

survey_qtpl

svy_qtpl

Survey_Stats

survey_statistics

svystat

Survey_Template

survey_tpl

svy_tpl

Survey_Tracking

survey_tracking

svytrk

Table_Name

tn

 

target_tgttpls_srvtypes

target_tgttpls_srvtypes

tgt_tgttpls_srvtypes

target_time

target_time

tgt_time

target_time_tpl

target_time_tpl

tgt_time_tpl

Task_Status

tskstat

tskstat

Task_Type

tskty

tskty

Zeitspanne

tspan

tspan

Zeitzone

tz

tz

Transition_Points

nottrn

 

True_False_Table

True_False_Table

true_false

Type_Of_Contact

toc

typecnt

Urgency

urgncy

urg

User_Query

usq

usq

usp_caextwf_instances

usp_caextwf_instances

caextwf_inst

usp_caextwf_start_forms

usp_caextwf_start_forms

caextwf_sfrm

usp_ci_window

usp_ci_window

ci_window

usp_contact

usp_contact

cnt

usp_functional_access

usp_functional_access

func_access

usp_functional_access_level

usp_functional_access_level

func_access_level

usp_functional_access_role

usp_functional_access_role

func_access_role

usp_functional_access_type

usp_functional_access_type

func_access_type

usp_kpi

usp_kpi

kc

usp_kpi_data

usp_kpi_data

kcd

usp_lrel_asset_chgnr

usp_lrel_asset_chgnr

lrel_asset_chgnr

usp_lrel_asset_issnr

usp_lrel_asset_issnr

lrel_asset_issnr

usp_lrel_att_cntlist_macro_ntf

usp_lrel_att_cntlist_macro_ntf

lrel_att_cntlist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

usp_lrel_att_ctplist_macro_ntf

lrel_att_ctplist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

usp_lrel_att_ntflist_macro_ntf

lrel_att_ntflist_macro_ntf

usp_lrel_attachments_changes

usp_lrel_attachments_changes

lrel_attachments_changes

usp_lrel_attachments_issues

usp_lrel_attachments_issues

lrel_attachments_issues

usp_lrel_attachments_requests

usp_lrel_attachments_requests

lrel_attachments_requests

usp_lrel_aty_events

usp_lrel_aty_events

lrel_aty_events

usp_lrel_bm_reps_assets

usp_lrel_bm_reps_assets

lrel_bm_reps_assets

usp_lrel_bm_reps_bmhiers

usp_lrel_bm_reps_bmhiers

lrel_bm_reps_bmhiers

usp_lrel_cenv_cntref

usp_lrel_cenv_cntref

lrel_cenv_cntref

usp_lrel_false_action_act_f

usp_lrel_false_action_act_f

lrel_false_action_act_f

usp_lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_cntlist_mgs_ntf

lrel_dist_cntlist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ctplist_mgs_ntf

lrel_dist_ctplist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

usp_lrel_dist_ntflist_mgs_ntf

lrel_dist_ntflist_mgs_ntf

usp_lrel_false_bhv_false

usp_lrel_false_bhv_false

lrel_false_bhv_false

usp_lrel_kwrds_crsolref

usp_lrel_kwrds_crsolref

lrel_kwrds_crsolref

usp_lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntchgntf

lrel_notify_list_cntchgntf

usp_lrel_notify_list_cntissntf

usp_lrel_notify_list_cntissntf

lrel_notify_list_cntissntf

usp_lrel_notify_list_cntntf

usp_lrel_notify_list_cntntf

lrel_notify_list_cntntf

usp_lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_cntl_att_ntfrl

lrel_ntfr_cntlist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_ctplist_att_ntfrl

lrel_ntfr_ctplist_att_ntfrlist

usp_lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_macrolist_att_ntfrl

lrel_ntfr_macrolist_att_ntfrl

usp_lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_ntfr_ntflist_att_ntfrl

lrel_ntfr_ntflist_att_ntfrlist

usp_lrel_oenv_orgref

usp_lrel_oenv_orgref

lrel_oenv_orgref

usp_lrel_status_codes_tsktypes

usp_lrel_status_codes_tsktypes

lrel_status_codes_tsktypes

usp_lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_chgcat

lrel_svc_grps_svc_chgcat

usp_lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_isscat

lrel_svc_grps_svc_isscat

usp_lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_pcat

lrel_svc_grps_svc_pcat

usp_lrel_svc_grps_svc_wftpl

usp_lrel_svc_grps_svc_wftpl

lrel_svc_grps_svc_wftpl

usp_lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_chgcat

lrel_svc_locs_svc_chgcat

usp_lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_groups

lrel_svc_locs_svc_groups

usp_lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_isscat

lrel_svc_locs_svc_isscat

usp_lrel_svc_locs_svc_pcat

usp_lrel_svc_locs_svc_pcat

lrel_svc_locs_svc_pcat

usp_lrel_svc_schedules_chgcat_svc

usp_lrel_svc_sch_chgcat_svc

lrel_svc_schedules_chgcat_svc

usp_lrel_svc_schedules_isscat_svc

usp_lrel_svc_sch_isscat_svc

lrel_svc_schedules_isscat_svc

usp_lrel_svc_schedules_pcat_svc

usp_lrel_svc_sch_pcat_svc

lrel_svc_schedules_pcat_svc

usp_lrel_true_action_act_t

usp_lrel_true_action_act_t

lrel_true_action_act_t

usp_lrel_true_bhv_true

usp_lrel_true_bhv_true

lrel_true_bhv_true

usp_kpi_ticket_data

usp_kpi_ticket_data

ktd

usp_organization

usp_organization

org

usp_owned_resource

usp_owned_resource

nr

usp_pri_cal

usp_pri_cal

 

USP_PREFERENCES

USP_PREFERENCES

USP_PREFERENCES

USP_PROPERTIES

USP_PROPERTIES

USP_PROPERTIES

Workflow_Task

wf

wf

Workflow_Task_Template

wftpl

wftpl

wspcol

wspcol

wspcol

wsptbl

wsptbl

wsptbl