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

JetDeleteColumn2 Function

· 52CE 我爱测

Learn more about: JetDeleteColumn2 Function

Applies to: Windows | Windows Server

JetDeleteColumn2 Function

The JetDeleteColumn2 function deletes a column from an ESE database table and enables a grbit option to be set.

Windows XP:  JetDeleteColumn2 is introduced in Windows XP.

    JET_ERR JET_API JetDeleteColumn2(
      __in          JET_SESID sesid,
      __in          JET_TABLEID tableid,
      __in          const tchar* szColumnName,
      __in          const JET_GRBIT grbit
    );

Parameters

sesid

The database session context to use for the API call.

tableid

The table that contains the column to be deleted.

szColumnName

The name of the column to be deleted.

grbit

A group of bits specifying zero or more of the following options.

Value Meaning
JET_bitDeleteColumnIgnoreTemplateColumns Setting JET_bitDeleteColumIgnoreTemplateColumns will cause the API to only attempt to delete columns in the derived table. If a column of that name exists in the base table it will be ignored.

Return Value

This function returns the JET_ERR datatype with one of the following return codes. For more information about the possible ESE errors, see Extensible Storage Engine Errors and Error Handling Parameters.

Return code Description
JET_errSuccess The operation completed successfully.
JET_errColumnInUse The column is currently in use. It may be currently used by an index.
JET_errFixedDDL An attempt was made to modify the fixed DDL.
JET_errFixedInheritedDDL The column named in szColumnName exists in the template table, and the DDL of a template table cannot be modified.
JET_errInvalidName This may be returned if a bad name for szColumnName was given.
JET_errPermissionDenied The table is not writable. This may get returned if the database was opened in read-only mode.
JET_errTransReadOnly The transaction is a read-only transaction.
Remarks

Calling JetDeleteColumn is identical to calling JetDeleteColumn2 with grbit set to zero (0).

Requirements
Requirement Value
Client Requires Windows Vista or Windows XP.
Server Requires Windows Server 2008 or Windows Server 2003.
Header Declared in Esent.h.
Library Use ESENT.lib.
DLL Requires ESENT.dll.
Unicode Implemented as JetDeleteColumn2W (Unicode) and JetDeleteColumn2A (ANSI).
See Also

JET_ERR
JET_GRBIT
JET_SESID
JET_TABLEID
JetDeleteColumn

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)

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

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