Mobile geodatabase size and name limits

Mobile geodatabase size and name limits are as follows:

  • Mobile geodatabase size: 2 TB database limit
  • Table or feature class size: No limit within the 2 TB database limit.
    Tip:

    SQLite is a self-contained database file format that stores the entire database in a single file on disk. Therefore, all SQLite database objects in a mobile geodatabase, such as the geodatabase tables, indexes, triggers, and views, consume some of the available space within this 2 TB limit.

  • Number of feature classes and tables: 2,147,483,647
  • Number of fields in a feature class or table: 2,000
  • Number of rows in a feature class or table: 2,147,483,647
  • Geodatabase name length: Number of characters the operating system allows in a folder name
    Note:

    • Since a mobile geodatabase (.geodatabase) is built on top of SQLite, the name of the mobile geodatabase consists of the file path, file name, and file extension.

      For example, if you are using a Windows operating system, the name of this mobile geodatabase, C:\GIS_Data\Projects\Mobile_Geodatabase\Project1_data.geodatabase, contains 65 characters.

    • The database names called main and temp are reserved SQLite database names.

  • Feature dataset name length: 160 characters
  • Feature class or table name length: 128 characters
  • Field name length: 31 characters
  • Text field width: 1,000,000,000 bytes

Related topics