The sdetype.h file that is installed with the ArcSDE SDK includes definitions for
ArcSDE objects. This includes definitions for the maximum lengths of object
names, such as tables and columns, and other object definition limits.
Each of these maximum values includes one null terminator; therefore, the
actual maximum value you can specify is one less than the maximum defined for
the object. For example, the defined maximum for table name length is 160
characters. The last character is a null terminator so the actual maximum number
of characters you can specify is 159.
The following is a list of some of the more frequently used objects
and their limit definitions:
| Annotation text |
SE_MAX_ANNO_TEXT_LEN |
30 |
Maximum number of characters in annotation
text |
| Column name |
SE_MAX_COLUMN_LENGTH |
32 |
Maximum number of characters in the name of
a column |
| Column name (fully qualified) |
SE_QUALIFIED_COLUMN_LEN |
SE_QUALIFIED_TABLE_NAME + SE_MAX_COLUMN_LEN
+ 1 |
Maximum number of characters in a fully
qualified column name |
| Columns |
SE_MAX_COLUMNS |
500 |
Maximum number of columns in a table |
| Database name |
SE_MAX_DATABASE_LEN |
32 |
Maximum number of characters in the name of
a database |
| DBMS hint |
SE_MAX_HINT_LEN |
1,024 |
Maximum number of characters that can be
used in a DBMS hint |
| DBTUNE configuration keyword |
SE_MAX_CONFIG_KEYWORD_LEN |
32 |
Maximum number of characters allowed in a
DBTUNE configuration keyword Corresponds to the definition of the keyword
column in the DBTUNE (or sde_dbtune) table: varchar(32) |
| DBTUNE configuration parameter name |
SE_MAX_PARAM_NAME_LEN |
32 |
Maximum number of characters allowed for a
DBTUNE configuration parameter name Corresponds to the definition of the
parameter_name column in the DBTUNE (or sde_dbtune) table: varchar(32) |
| DBTUNE configuration string |
SE_MAX_CONFIG_STR_LEN |
2,048 |
Maximum character length of the value
designated for the configuration parameter
Corresponds to the definition of the config_string column in the DBTUNE (or
sde_dbtune)
table: varchar(2048) |
| Description |
SE_MAX_DESCRIPTION_LEN |
64 |
Maximum number of characters used for an
object's description |
| Error message |
SE_MAX_MESSAGE_LENGTH |
512 |
Maximum number of characters in an error
message |
| File path |
SE_MAX_PATH_LEN |
512 |
Maximum number of characters in a file path |
| Function name |
SE_MAX_FUNCTION_LEN |
32 |
Maximum number of characters in the name of
a database function |
| Index name |
SE_MAX_INDEX_LEN |
128 |
Maximum number of characters in the name of
a database index |
| Instance name |
SE_MAX_INSTANCE_LEN |
1,024 |
Maximum number of characters used in the
ArcSDE instance connection string This could be the ArcSDE instance name or
port, or it could be the syntax to make a direct connection to the geodatabase. |
| Metadata class |
SE_MAX_METADATA_CLASS_LEN |
32 |
Maximum number of characters used in the
name of a metadata class |
| Metadata property |
SE_MAX_METADATA_PROPERTY_LEN |
32 |
Maximum number of characters used in a
metadata property name |
| Metadata value |
SE_MAX_METADATA_VALUE_LEN |
255 |
Maximum number of characters for the value
of a metadata object |
| Object name |
SE_MAX_OBJECT_NAME_LEN |
160 |
Maximum number of characters used in a
metadata object's name |
| Owner name |
SE_MAX_OWNER_LEN |
32 |
Maximum number of characters in the name of
a table owner |
| Password |
SE_MAX_PASSWORD_LEN |
256 |
Maximum number of characters in a database
or operating system password used to log into the geodatabase |
| Schema name |
SE_MAX_SCHEMA_LEN |
32 |
Maximum number of characters in the
name of a user's schema Remember, the schema name and owner name must be the
same. |
| Server name |
SE_MAX_SERVER_LEN |
256 |
Maximum number of characters in the
data source or server name used to connect to the geodatabase |
| SQL message |
SE_MAX_SQL_MESSAGE_LENGTH |
4,096 |
Maximum number of characters in a SQL error
message |
| Table alias |
SE_MAX_ALIAS_LEN |
32 |
Maximum number of characters in the alias of
a table |
| Table name |
SE_MAX_TABLE_LEN |
160 |
Maximum number of characters in the name of
a table |
| Table name (fully qualified) |
SE_QUALIFIED_TABLE_NAME |
SE_MAX_DATABASE_LEN + SE_MAX_OWNER_LEN +
SE_MAX_TABLE_LEN + 2 |
Maximum number of characters in a fully
qualified table name |
| UUID |
SE_UUID_STRING_LEN |
40 |
Maximum number of characters that can be
used in a UUID string |
| Version name |
SE_MAX_VERSION_LEN
or SE_MAX_VERSION_INPUT_LEN |
32 |
Maximum number of characters that can be
used in the name of a geodatabase version |
| Version name (fully qualified) |
SE_QUALIFIED_VERSION_LEN |
SE_MAX_OWNER_LEN + SE_MAX_VERSION_LEN + 1 |
Maximum number of characters in the
fully qualified name of a geodatabase version |
| XML index name |
SE_MAX_XML_INDEX_NAME_LEN |
32 |
Maximum number of characters in the name of
an XML index |
| XML index name (fully qualified) |
SE_QUALIFIED_XML_INDEX_LEN |
SE_MAX_XML_INDEX_NAME_LEN + SE_MAX_OWNER_LEN
+ 1 |
Maximum number of characters in the fully
qualified name of an XML index |
| XML schema name |
SE_MAX_XML_SCHEMA_NAME_LEN |
1,000 |
Maximum number of characters in the name of
an XML schema |
| XML tag name |
SE_MAX_XML_TAG_NAME_LEN |
1,024 |
Maximum number of characters in the name of
an XML tag |
