

When creating an integer field, specify a precision of 10 or less, or your field may be created as a double. If you specify a scale of 0 and a precision of 10 or less, create an integer field.If you create a float field and specify a precision greater than 6, a double field will be created. If you create a double field and specify a precision of 6 or less, a float field will be created. When you create float and double fields and specify a precision and scale, if the precision is greater than 6, use a double otherwise, use a float.File geodatabases support only binary type fields, and precision and scale are ignored. When you create a float, double, or integer field and specify 0 for precision and scale, the tool will attempt to create a binary type field if the underlying database supports it.Use the following guidelines for choosing the correct field type for a given precision and scale: For example, if the field value is 54.234, scale = 3 and precision = 5. The precision describes the number of digits that can be stored in the field, and the scale describes the number of decimal places for float and double fields. The precision and scale of a field describe the maximum precision and size of data that can be stored in the field. Providing an invalid domain name or value will not cause the tool to fail, but the invalid name or value will be ignored and no domain will be set for the field. The name of an existing domain must be provided. The Field Domain parameter can use an existing domain from a feature class in a geodatabase.

If a length is not specified, the length will default to 255.įor geodatabases, if field type defines a character or number, is inserted into each record if the Field Is Nullable parameter is checked ( field_is_nullable="NULLABLE" in Python).Ī nonnullable field cannot be added to a nonempty geodatabase feature class or table.Ī shapefile does not support aliases for fields, so you cannot add a field alias to a shapefile. The Field Length parameter is only applicable to fields of type text. If field type defines a numeric item, zeros are inserted for each record. For shapefiles and dBase tables, if field type defines a character, blanks are inserted for each record.
