大网数据广告活动
安装更新与部署

_Validation Table

· 52CE 我爱测

The _Validation table is a system table that contains the column names and the column values for all of the tables in the database.

The _Validation table is a system table that contains the column names and the column values for all of the tables in the database. It is used during the database validation process to ensure that all columns are accounted for and have the correct values. This table is not shipped with the installer database.

The _Validation table has the following columns.

Column Type Key Nullable
Table Identifier Y N
Column Identifier Y N
Nullable Text N N
MinValue DoubleInteger N Y
MaxValue DoubleInteger N Y
KeyTable Identifier N Y
KeyColumn Integer N Y
Category Text N Y
Set Text N Y
Description Text N Y

Columns

Table

Used to identify a particular table. This key and the Column key form the primary key of the _Validation table.

Column

Used to identify a particular column of the table. This key and the Table key form the primary key of the _Validation table.

Nullable

Identifies whether the column may contain a Null value.

This column may have one of the following values.

String Meaning
Y Yes, the column may have a Null value.
N No, the column may not have a Null value.

MinValue

This field applies to columns having numeric value. The field contains the minimum permissible value. This can be the minimum value for an integer or the minimum value for a date or version string.

MaxValue

This field applies to columns having numeric value. The field is the maximum permissible value. This may be the maximum value for an integer or the maximum value for a date or version string.

KeyTable

This field applies to columns that are external keys. The field identified in Column must link to the column number specified by KeyColumn in the table named in KeyTable. This can be a list of tables separated by semicolons.

KeyColumn

This field applies to table columns that are external keys. The field identified in Column must link to the column number specified by KeyColumn in the table named in KeyTable. The permissible range of the KeyColumn field is 1-32.

Category

This is the type of data contained by the database field specified by the Table and Column columns of the _Validation table. If this is a type having a numeric value, such as Integer, DoubleInteger or Time/Date, then enter null into this field and specify the value's range using the MinValue and MaxValue columns. Use the Category column to specify the non-numeric data types described in Column Data Types.

Set

This is a list of permissible values for this field separated by semicolons. This field is usually used for enumerations.

Description

A description of the data that is stored in the column.

Validation

ICE03
ICE06
ICE32

Remarks

The Category field of this table only applies to string data. If the Column field refers to a column with binary data, the binary data type must be specified in the Category field. Integer data Column types ignore the Category field during validation.

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 05/31/2018
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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