大网数据广告活动
磁盘与文件系统

Maximum Settings Constants

· 52CE 我爱测

Learn more about: Maximum Settings Constants

Applies to: Windows | Windows Server

Maximum Settings Constants

These constants provide the maximum settings that are allowed on items in an ESE database.

Constant/value Description
JET_BASE_NAME_LENGTH3 Sets the length for the prefix used to name files that are used by the database engine. This length is applicable to the name set for the <a href="gg269235(v=exchg.10).md">JET_paramBaseName</a> system parameter.
JET_MAX_COMPUTERNAME_LENGTH15 Sets the maximum length for <a href="gg269340(v=exchg.10).md">JET_SIGNATURE</a>.
JET_cbBookmarkMost256 The default maximum size of a bookmark. This is valid when the key size is left at its default value.
JET_cbBookmarkMostMost2000 The maximum size of a bookmark when esent is configured to have the largest keys possible.Windows 7: JET_cbBookmarkMostMost is introduced in Windows 7.
JET_cbNameMost64 The maximum length of a object, column, index, or property name.Note  If Unicode, the value is 128.
JET_cbFullNameMost255 The maximum length of a "name.name.name..." construct.Note  If Unicode, the value is 510.
JET_cbColumnLVPageOverhead82 This number can be used to compute the maximum amount of a BLOB that can be stored by the database engine on a single database page. The formula is max size = JET_paramDatabasePageSize–JET_cbColumnLVPageOverhead.This value is now obsolete. The long-value chunk size should be retrieved with the JET_paramLVChunkSizeMost parameter.
JET_cbColumnMost255 The maximum size of non-long-value column data.
JET_cbLVDefaultValueMost255 The maximum size of a long-value (LongBinary or LongText) column default value.
JET_cbKeyMost255 The default maximum size of a sort or index key.
JET_cbKeyMostMost2000 The maximum configurable size of a sort or index key for any page size. (See JET_INDEXCREATE2.cbKeyMost)Windows 7: JET_cbKeyMostMost is introduced in the Windows 7 operating system.
JET_cbKeyMost2KBytePage500 The maximum allowable maximum configurable size for an index key in a database using 2048 byte pages. See <a href="gg269186(v=exchg.10).md">JET_INDEXCREATE</a> for more information.Windows Vista: JET_cbKeyMost2KBytePage is introduced in the Windows Vista operating system.
JET_cbKeyMost4KBytePage1000 The maximum allowable maximum configurable size for an index key in a database using 4096 byte pages. See <a href="gg269186(v=exchg.10).md">JET_INDEXCREATE</a> for more information.Windows Vista: JET_cbKeyMost4KBytePage is introduced in Windows Vista.
JET_cbKeyMost8KBytePage2000 The maximum allowable maximum configurable size for an index key in a database using 8192 byte pages. See <a href="gg269186(v=exchg.10).md">JET_INDEXCREATE</a> for more information.Windows Vista:  JET_cbKeyMost8KBytePage is introduced in Windows Vista
JET_cbKeyMostMin255 The minimum allowable maximum size for an index key. See <a href="gg269186(v=exchg.10).md">JET_INDEXCREATE</a> for more information.Windows Vista:  JET_cbKeyMostMin is introduced in Windows Vista.
JET_cbLimitKeyMost256 The maximum key size when the key is formed by using a limit grbit, such as JET_bitStrLimit, which is used in the <a href="gg269329(v=exchg.10).md">JetMakeKey</a> function.
JET_cbPrimaryKeyMost255 The maximum size of the primary index. This is now obsolete.
JET_cbSecondaryKeyMost255 The maximum size of the secondary index. This is now obsolete.
JET_ccolKeyMost12 The maximum number of components in a sort or index key.Windows Vista:  In Windows Vista and later versions of Windows the value is 16.
JET_ccolMost0x0000fee0 The maximum number of columns allowed in a table.Windows XP:  The value 0x0000fee0 is used in Windows XP and later and later versions of WindowsWindows 2000:  The value 0x00007ffe is used in Windows 2000.
JET_ccolFixedMost0x0000007f The maximum number of fixed columns allowed in a table, currently 127.
JET_ccolVarMost0x00000080 The maximum number of variable-length columns that can be contained in a table, currently 128.
JET_ccolTaggedMost( JET_ccolMost - 0x000000ff ) The maximum number of tagged columns that can be contained in a table, currently 64993.

Requirements

Requirement Value
Client Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Server Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Header Declared in Esent.h.

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。