Enterprise geodatabase size and name limits
Limits on the size of database objects in an enterprise geodatabase are mostly dependent on hardware limitations. Limits on database object name sizes is the smaller of either the limit enforced by the database management system (DBMS) or geodatabase limit. Limits vary from DBMS to DBMS. The types of characters allowed in object names also varies by DBMS but are also affected by how ArcGIS stores and queries the object information.
Size limits
Most size limits in a database depend on the DBMS edition and hardware limitations. One exception is the number of fields (columns) supported in a table or feature class; the maximum number is 500. Be aware, though, that depending on the data types, the maximum number of columns in a table could be less than 500. Most database vendors do not recommend creating tables with over 200 columns of any data type.
Number of characters in object names
The number of characters listed assumes the use of ANSI text. UTF-8 characters use twice as many bytes as ANSI characters, thereby halving the number of allowed characters.
DB2 9.x | Informix 11.x | Oracle 10g and 11g | PostgreSQL 9.x | SQL Server 2008 and 2012 | |
|---|---|---|---|---|---|
Database name | 8 | 31 | 30 | 31 | 31 |
Field (column) name | 31 | 31 | 30 | 31 | 31 |
Index name | 128 | 128 | 30 | 63 | 128 |
Password | 31 | 31 | 31 | 31 | 31 |
Table or feature class alias | 31 | 31 | 30 | 31 | 31 |
Table or feature class name | 128 | 128 | 30 | 63 | 128 |
User name | 30 | 31 | 30 | 31 | 31 |
Version name | 64 | 64 | 64 | 64 | 64 |
Versioned view name | 32 | 32 | 30 | 32 | 32 |
View name | 128 | 128 | 30 | 63 | 128 |
Character type limits in object names
Database management systems have different definitions of acceptable characters for object names. Most must begin with a letter and cannot contain spaces or back slashes. Some allow special characters such as forward slashes (/), underscores (_), dollar signs ($), dashes (-), dots (.), or mixed cases. Sometimes, the DBMS allows you to use special characters or force mixed, upper-, or lowercase names if you provide the object name enclosed in double quotation marks. However, do not create any tables, feature classes, databases, users, roles, or other object names using double quotation marks if you will be using it with ArcGIS; the object will be created in the database exactly as typed, but ArcGIS will not recognize it, which means you will not be able to access it from ArcGIS.