Views


TableDescription
dbo01.viewQueryListConfiguration View of Query List with All Database Objects
dbo01.viewQueryListToolsConfiguration View of Query List of Framework Tools
xls01.viewColumnTranslationConfiguration View of Column Translation
xls01.viewEventHandlersConfiguration View of Excel Event Handlers
xls01.viewObjectDescriptionDatabase Object Descriptions
xls01.viewObjectTranslationConfiguration View of Object Translation
xls01.viewParameterValuesConfiguration View of Parameter Value Queries
xls01.viewQueryListConfiguration View of Query List
xls01.viewTableFormatsConfiguration View of Excel Table Formats

dbo01.viewQueryList

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
TABLE_TYPEnvarchar(128)
TABLE_CODEnvarchar(max)
INSERT_PROCEDUREnvarchar(max)
UPDATE_PROCEDUREnvarchar(max)
DELETE_PROCEDUREnvarchar(max)
PROCEDURE_TYPEnvarchar(128)

The view selects all the database objects and is used as a source for other query list views

dbo01.viewQueryListTools

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
TABLE_TYPEnvarchar(128)
TABLE_CODEnvarchar(max)
INSERT_PROCEDUREnvarchar(max)
UPDATE_PROCEDUREnvarchar(max)
DELETE_PROCEDUREnvarchar(max)
PROCEDURE_TYPEnvarchar(128)

The view selects SaveToDB Framework Tools objects

xls01.viewColumnTranslation

ColumnDataTypeComment
IDint
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
COLUMN_NAMEnvarchar(128)
LANGUAGE_NAMEchar(2)
TRANSLATED_NAMEnvarchar(128)
TRANSLATED_DESCnvarchar(1024)

The view selects column translation data used by the SaveToDB add-in

xls01.viewEventHandlers

ColumnDataTypeComment
IDint
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
COLUMN_NAMEnvarchar(128)
EVENT_NAMEvarchar(50)
HANDLER_SCHEMAnvarchar(128)
HANDLER_NAMEnvarchar(128)
HANDLER_TYPEnvarchar(128)
HANDLER_CODEnvarchar(max)
TARGET_WORKSHEETnvarchar(128)
MENU_ORDERint
EDIT_PARAMETERSbit

The view selects event handler configurations used by the SaveToDB add-in

xls01.viewObjectDescription

ColumnDataTypeComment
IDint
LANGUAGE_NAMEchar(2)
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
TRANSLATED_NAMEnvarchar(128)
TRANSLATED_COMMENTnvarchar(4000)

You may use Query List to connect to these objects

xls01.viewObjectTranslation

ColumnDataTypeComment
IDint
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
LANGUAGE_NAMEchar(2)
TRANSLATED_NAMEnvarchar(128)
TRANSLATED_DESCnvarchar(255)
TRANSLATED_COMMENTnvarchar(4000)

The view selects object translation data used by the SaveToDB add-in

xls01.viewParameterValues

ColumnDataTypeComment
IDint
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
PARAMETER_NAMEnvarchar(128)
SELECT_SCHEMAnvarchar(128)
SELECT_NAMEnvarchar(128)
SELECT_TYPEnvarchar(128)
SELECT_CODEnvarchar(max)

The view selects parameter configurations used by the SaveToDB add-in

xls01.viewQueryList

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
TABLE_TYPEnvarchar(128)
TABLE_CODEnvarchar(max)
INSERT_PROCEDUREnvarchar(max)
UPDATE_PROCEDUREnvarchar(max)
DELETE_PROCEDUREnvarchar(max)
PROCEDURE_TYPEnvarchar(128)

The view selects a database object list used by the SaveToDB add-in

xls01.viewTableFormats

ColumnDataTypeComment
IDint
TABLE_SCHEMAnvarchar(128)
TABLE_NAMEnvarchar(128)
TABLE_EXCEL_FORMAT_XMLxml

The view selects saved table formats used by the SaveToDB add-in