This documentation supports the 18.08 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

SQL definitions of the data dictionary tables

The SQL commands that define the data dictionary for the AR System database are in the following files:

  • ARSystemServerInstallDir/Logs/arsystem_create_tab.txt
    This file is created when you install the AR System server for the first time or when you overwrite your current server installation. It contains all the SQL commands required to create the default data dictionary for your AR System database type. This file is not deleted or modified when you upgrade your server.
  • ARSystemServerInstallDir/Logs/arsystem_upgrade_sql.txt
    When you upgrade your AR System server, this file is created to record the differences between the SQL commands used to create the data dictionary in your previous version of the AR System database and in your upgraded version.
    Each subsequent upgrade overwrites this file. Therefore, to save its contents, rename it before performing another upgrade.

    The names of these files are the same for all database types.

    To view the contents of these files in a reader-friendly format, open them in WordPad.

    For more information about the SQL commands that define the AR System data dictionary, see the following documents:


    Database type

    Document

    Microsoft SQL Server

    Transact-SQL Desk Reference: For Microsoft SQL Server

    Oracle

    Oracle SQL Reference Manual

Was this page helpful? Yes No Submitting... Thank you

Comments