Tables


TableDescription
dbo01.ColumnTranslationConfiguration Table of Column Translation
dbo01.EventHandlersConfiguration Table of Excel Event Handlers
dbo01.ObjectTranslationConfiguration Table of Object Translation
dbo01.ParameterValuesConfiguration Table of Parameter Value Queries
dbo01.QueryListConfiguration Table of Query List
dbo01.TableFormatsConfiguration Table of Excel Table Formats

dbo01.ColumnTranslation

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)Database object schema or NULL for entire database scope
TABLE_NAMEnvarchar(128)Database object name or NULL for entire schema scope
COLUMN_NAMEnvarchar(128)NOT NULLColumn or parameter name
LANGUAGE_NAMEchar(2)NOT NULLTwo-char language code
TRANSLATED_NAMEnvarchar(128)Translated name for Excel table headers and ribbon parameters
TRANSLATED_DESCnvarchar(1024)Text for Excel table header comments and ribbon parameter SuperTips

The table defines translation for Excel table headers and ribbon fields

dbo01.EventHandlers

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)NOT NULLDatabase object schema
TABLE_NAMEnvarchar(128)NOT NULLDatabase object name, SQL-code name, or http-query name
COLUMN_NAMEnvarchar(128)Column name or NULL to use the handler for entire table
EVENT_NAMEvarchar(50)NOT NULLActions, Change, ContextMenu, DoubleClick, or SelectionChange
HANDLER_SCHEMAnvarchar(128)Database object schema
HANDLER_NAMEnvarchar(128)NOT NULLDatabase object name, unique name for SQL-code and http-query, or MenuSeparator
HANDLER_TYPEnvarchar(128)Database object type, CODE for SQL-code, HTTP for http-query, or NULL for MenuSeparator
HANDLER_CODEnvarchar(max)
TARGET_WORKSHEETnvarchar(128)NULL, sheet name, _new, _self, _reload. Additions: _RightWindow, _LeftWindow, _TopWindow, _BottomWindow
MENU_ORDERintSort order of Actions and Context Menu items
EDIT_PARAMETERSbitShow the Edit Parameters dialog box for Actions and Context Menu items: True/False/NULL (default behavior)
IS_ACTIVEbitTrue if the handler is active.

The table defines Excel event handlers and Actions and Context Menu items

dbo01.ObjectTranslation

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)NOT NULLDatabase object schema
TABLE_NAMEnvarchar(128)NOT NULLDatabase object name or a name of SQL-code or http-query specified in Query List and Event Handlers
LANGUAGE_NAMEchar(2)NOT NULLTwo-char language code
TRANSLATED_NAMEnvarchar(128)Translated name for Query List, Actions and Context Menus
TRANSLATED_DESCnvarchar(255)Text for ScreenTips and SaveToDB_Desc named cells
TRANSLATED_COMMENTnvarchar(4000)Text for SuperTips and SaveToDB_Comment named cells

The table defines translation for Query List, Actions and Context Menu items

dbo01.ParameterValues

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)NOT NULLDatabase object schema
TABLE_NAMEnvarchar(128)NOT NULLDatabase object name
PARAMETER_NAMEnvarchar(128)NOT NULLColumn or parameter name
SELECT_SCHEMAnvarchar(128)Database object schema
SELECT_NAMEnvarchar(128)NOT NULLDatabase object name or name for SQL-code
SELECT_TYPEnvarchar(128)Database object type or CODE for SQL-code
SELECT_CODEnvarchar(max)

The table defines objects to select ribbon parameter values

dbo01.QueryList

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)NOT NULLDatabase object schema
TABLE_NAMEnvarchar(128)NOT NULLDatabase object name or unique name for SQL-code and http-query
TABLE_TYPEnvarchar(128)NOT NULLDatabase object type, CODE for SQL-code, or HTTP for http-query
TABLE_CODEnvarchar(max)
INSERT_PROCEDUREnvarchar(max)Insert procedure or destination table to save changes of views, procedures, or SQL-codes
UPDATE_PROCEDUREnvarchar(max)Update procedure or destination table to save changes of views, procedures, or SQL-codes
DELETE_PROCEDUREnvarchar(max)Delete procedure or destination table to save changes of views, procedures, or SQL-codes
PROCEDURE_TYPEnvarchar(128)

The table defines configuration of Query List objects

dbo01.TableFormats

ColumnDataTypeNullableIdentityKeyComment
IDintNOT NULLIDENTITYPK
TABLE_SCHEMAnvarchar(128)NOT NULLDatabase object schema
TABLE_NAMEnvarchar(128)NOT NULLDatabase object name
TABLE_EXCEL_FORMAT_XMLxmlExcel table format XML

The table contains Excel formats of database objects