Skip to main content

更改字段 (多个) (数据管理工具)

汇总

用于更改要素类或表中多个字段的字段属性。

用法

注意:

此工具会修改输入数据。 有关详细信息以及避免意外更改数据的策略,请参阅 修改或更新输入数据的工具

  • 此工具用于重命名地理数据库表或要素类的字段或字段别名。

  • 可以使用此工具修改已注册到地理数据库的表或视图中字段的字段别名。

  • 如果输入字段为必填字段,则只能修改字段别名。

参数

标注 说明 数据类型

输入表

包含要更改的字段的输入地理数据库表或要素类。

Table View; Raster Layer; Mosaic Layer

字段属性

(可选)

将被修改的输入表字段及其属性。

值表列:

  • Field NameThe name of the field that will be altered. If the field is a required field, only the field alias will be altered.

  • New Field NameThe new name for the field.

  • New Field AliasThe new field alias for the field.

  • New Field TypeSpecifies the new field type for the field. This option is only applicable if the input table is empty (does not contain records).

    • Short (16-bit integer)The field type will be short. Short fields support whole numbers between -32,768 and 32,767.

    • Long (32-bit integer)The field type will be long. Long fields support whole numbers between -2,147,483,648 and 2,147,483,647.

    • Big integer (64-bit integer)The field type will be big integer. Big integer fields support whole numbers between -(253) and 253.

    • Float (32-bit floating point)The field type will be float. Float fields support fractional numbers between -3.4E38 and 1.2E38.

    • Double (64-bit floating point)The field type will be double. Double fields support fractional numbers between -2.2E308 and 1.8E308.

    • TextThe field type will be text. Text fields support a string of characters.

    • DateThe field type will be date. Date fields support date and time values.

    • Date onlyThe field type will be date only. Date only fields support date values with no time values.

    • Time onlyThe field type will be time only. Time only fields support time values with no date values.

    • Timestamp offsetThe field type will be timestamp offset. Timestamp offset fields support a date, time, and offset from a UTC value.

    • BLOB (binary data)The field type will be BLOB. BLOB fields support data stored as a long sequence of binary numbers. You need a custom loader or viewer or a third-party application to load items into a BLOB field or view the contents of a BLOB field.

    • GUID (globally unique identifier)The field type will be GUID. GUID fields store registry-style strings consisting of 36 characters enclosed in curly brackets.

    • RasterThe field type will be raster. Raster fields can store raster data in or alongside the geodatabase. All ArcGIS software-supported raster dataset formats can be stored, but it is recommended that only small images be used.

  • New Field LengthThe new length of the field. This sets the maximum number of allowable characters for each record of the field. This option is only applicable to fields of type Text or Blob. If the table is empty, the field length can be increased or decreased. If the table is not empty, the length can only be increased from the current value.

  • New Field Is NullableSpecifies whether the field can contain null values.

  • Clear AliasSpecifies whether the alias for the input field will be cleared.

Value Table

派生输出

标注 说明 数据类型

更新的输入表

更新的输入表。

Table View; Raster Layer; Mosaic Layer

环境

当前工作空间

许可信息

  • 基本: 是
  • 标准: 是
  • 高级: 是