Create a remote table

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：4分

    • Create a remote table using data retrieved from an external source.

    始める前に

    Role required: delegated_developer or admin

    このタスクについて

    When you designate a table as a remote table, keep the following points in mind:
    • Before you create a remote table, you must have a good understanding of external data sources. For example, if you want to retrieve CRM data for use in Customer Service Management, you must understand how the data is structured in the external CRM source.
    • A remote table needs an external primary key to relate its temporary data to the data that is stored in the external source. When you designate a table as remote, only a sys_id field is auto-generated and appears in the Columns section, which it uses as its primary key for use in Glide records. All external table primary key values are converted to string values.
    • Unlike standard internal tables, you can't extend a remote table from another table.

    手順

    1. Navigate to System Definition > Remote Tables > Tables.
      ヒント:
      You can also create a remote table using the standard form for tables from System Definition > Tables.
    2. Select New.
    3. On the form, fill in the fields.
      注:
      You create a remote table in the same manner as a normal table, but designate it as a remote table. The following controls differ in how they operate and what you enter into them when you create a remote table:
      Control Description
      Name
      Table name, which is automatically populated based on the table label and a prefix as follows:
      • For a remote table in a scoped application, the name is prefixed with a namespace identifier and the string st_ to indicate that it’s remote and part of an application.
      • For a remote table in the global application, the name is prefixed with the string u_st_.

      You can't modify the prefix; however, you can modify the rest of the table name. The name can contain only lowercase, alphanumeric ASCII characters and underscores (_).
      Extends Table Option that is not available if you select the Remote Table option to designate that this table is remote. It no longer appears because you can't extend remote tables from other tables.
      Remote Table Option to designate this table as a remote table. A remote table is a table to which you can associate a script definition for retrieval of data from an external data source. Unlike a standard internal table, the data doesn’t come from records in the current instance.

      To learn more about remote tables, see Remote tables.
    4. In the Columns section, use the Table Columns embedded list to add columns to the remote table like you do when you create columns for a standard internal table.
    5. In the Controls section, define additional remote table options like you do when you define additional table options for a normal table.
    6. In the Application Access section, define the scope protection for the remote table like you do when you define additional table options for a normal table.
      For more information, see Application access settings.
    7. Select Submit.