OleDbLiteral 枚举

定义

返回有关文本命令、数据值和数据库对象中使用的文本的信息。Returns information about literals used in text commands, data values, and database objects.

public enum class OleDbLiteral
public enum OleDbLiteral
type OleDbLiteral = 
Public Enum OleDbLiteral
继承
OleDbLiteral

字段

Binary_Literal 1

文本命令中的二进制文本。A binary literal in a text command. 映射到 DBLITERAL_BINARY_LITERAL。Maps to DBLITERAL_BINARY_LITERAL.

Catalog_Name 2

文本命令中的目录名。A catalog name in a text command. 映射到 DBLITERAL_CATALOG_NAME。Maps to DBLITERAL_CATALOG_NAME.

Catalog_Separator 3

文本命令中将目录名与标识符的其余部分隔开的字符。The character that separates the catalog name from the rest of the identifier in a text command. 映射到 DBLITERAL_CATALOG_SEPARATOR。Maps to DBLITERAL_CATALOG_SEPARATOR.

Char_Literal 4

文本命令中的字符文本。A character literal in a text command. 映射到 DBLITERAL_CHAR_LITERAL。Maps to DBLITERAL_CHAR_LITERAL.

Column_Alias 5

文本命令中的列别名。A column alias in a text command. 映射到 DBLITERAL_COLUMN_ALIAS。Maps to DBLITERAL_COLUMN_ALIAS.

Column_Name 6

用于文本命令或数据定义接口中的列名。A column name used in a text command or in a data-definition interface. 映射到 DBLITERAL_COLUMN_NAME。Maps to DBLITERAL_COLUMN_NAME.

Correlation_Name 7

文本命令中的相关名称(表别名)。A correlation name (table alias) in a text command. 映射到 DBLITERAL_CORRELATION_NAME。Maps to DBLITERAL_CORRELATION_NAME.

Cube_Name 21

架构(如果提供程序不支持架构,则为目录)中多维数据集的名称。The name of a cube in a schema (or the catalog if the provider does not support schemas).

Cursor_Name 8

文本命令中的游标名。A cursor name in a text command. 映射到 DBLITERAL_CURSOR_NAME。Maps to DBLITERAL_CURSOR_NAME.

Dimension_Name 22

维的名称。The name of the dimension. 如果维是不止一个多维数据集是一部分,则针对每个多维数据集/维的组合都有一行。If a dimension is part of more than one cube, there is one row for each cube/dimension combination.

Escape_Percent_Prefix 9

LIKE 子句中使用的字符,用于转义为 DBLITERAL_LIKE_PERCENT 文本返回的字符。The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_PERCENT literal. 例如,如果百分号 (%) 用于匹配零个或更多个字符,而且这是一个反斜杠 (\),则字符“abc\%%”与所有以“abc%”开头的字符值都匹配。For example, if a percent sign (%) is used to match zero or more characters and this is a backslash (\), the characters "abc\%%" match all character values that start with "abc%". 某些 SQL 方言支持可用于重写此值的子句(ESCAPE 子句)。Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. 映射到 DBLITERAL_ESCAPE_PERCENT_PREFIX。Maps to DBLITERAL_ESCAPE_PERCENT_PREFIX.

Escape_Percent_Suffix 29

转义符(如果有的话),用于为 DBLITERAL_LIKE_PERCENT 文本返回的字符添加后缀。The escape character, if any, used to suffix the character returned for the DBLITERAL_LIKE_PERCENT literal. 例如,如果百分号 (%) 用于匹配零个或多个字符,而且百分号通过括在左右方括号中进行转义,则 DBLITERAL_ESCAPE_PERCENT_PREFIX 就是“[”,DBLITERAL_ESCAPE_PERCENT_SUFFIX 就是“]”,而字符“abc[%]%”就匹配所有以“abc%”开头的字符值。For example, if a percent sign (%) is used to match zero or more characters and percent signs are escaped by enclosing in open and close square brackets, DBLITERAL_ESCAPE_PERCENT_PREFIX is "[", DBLITERAL_ESCAPE_PERCENT_SUFFIX is "]", and the characters "abc[%]%" match all character values that start with "abc%". 不使用后缀字符来转义 DBLITERAL_ESCAPE_PERCENT 字符的提供程序不会返回此文本值,它们可以在需要时将 DBLITERAL 结构的 lt 成员设置为 DBLITERAL_INVALID。Providers that do not use a suffix character to escape the DBLITERAL_ESCAPE_PERCENT character do not return this literal value and can set the lt member of the DBLITERAL structure to DBLITERAL_INVALID if requested. 映射到 DBLITERAL_ESCAPE_PERCENT_SUFFIX。Maps to DBLITERAL_ESCAPE_PERCENT_SUFFIX.

Escape_Underscore_Prefix 10

LIKE 子句中使用的字符,用于转义为 DBLITERAL_LIKE_UNDERSCORE 文本返回的字符。The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_UNDERSCORE literal. 例如,如果下划线 (_) 用于正好匹配一个字符,并且这是一个反斜杠 (\),则字符“abc\_ _”与长度为 5 个字符并以“abc_”开头的所有字符值相匹配。For example, if an underscore (_) is used to match exactly one character and this is a backslash (\), the characters "abc\_ _" match all character values that are five characters long and start with "abc_". 某些 SQL 方言支持可用于重写此值的子句(ESCAPE 子句)。Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. 映射到 DBLITERAL_ESCAPE_UNDERSCORE_PREFIX。Maps to DBLITERAL_ESCAPE_UNDERSCORE_PREFIX.

Escape_Underscore_Suffix 30

LIKE 子句中使用的字符,用于转义为 DBLITERAL_LIKE_UNDERSCORE 文本返回的字符。The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_UNDERSCORE literal. 例如,如果下划线 (_) 用于正好匹配一个字符,并且这是一个反斜杠 (\),则字符“abc\_ _”与长度为 5 个字符并以“abc_”开头的所有字符值相匹配。For example, if an underscore (_) is used to match exactly one character and this is a backslash (\), the characters "abc\_ _" match all character values that are five characters long and start with "abc_". 某些 SQL 方言支持可用于重写此值的子句(ESCAPE 子句)。Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. 映射到 DBLITERAL_ESCAPE_UNDERSCORE_SUFFIX。Maps to DBLITERAL_ESCAPE_UNDERSCORE_SUFFIX.

Hierarchy_Name 23

层次结构的名称。The name of the hierarchy. 如果该维不包含层次结构或者只有一个层次结构,则当前列包含空值。If the dimension does not contain a hierarchy or has only one hierarchy, the current column contains a null value.

Index_Name 11

用于文本命令或数据定义接口中的索引名称。An index name used in a text command or in a data-definition interface. 映射到 DBLITERAL_INDEX_NAME。Maps to DBLITERAL_INDEX_NAME.

Invalid 0

一个无效值。An invalid value. 映射到 DBLITERAL_INVALID。Maps to DBLITERAL_INVALID.

Level_Name 24

当前级别所属的多维数据集的名称。Name of the cube to which the current level belongs.

Like_Percent 12

在 LIKE 子句中用以匹配零个或多个字符的字符。The character used in a LIKE clause to match zero or more characters. 例如,如果这是一个百分号 (%),则字符“abc%”就与所有以“abc”开头的字符值相匹配。For example, if this is a percent sign (%), the characters "abc%" match all character values that start with "abc". 映射到 DBLITERAL_LIKE_PERCENT。Maps to DBLITERAL_LIKE_PERCENT.

Like_Underscore 13

在 LIKE 子句中用以只匹配一个字符的字符。The character used in a LIKE clause to match exactly one character. 例如,如果这是一个下划线 (),则字符“abc_”与所有长度为 4 个字符并以“abc”开头的所有字符值相匹配。For example, if this is an underscore (), the characters "abc_" match all character values that are four characters long and start with "abc". 映射到 DBLITERAL_LIKE_UNDERSCORE。Maps to DBLITERAL_LIKE_UNDERSCORE.

Member_Name 25

成员名。The name of the member.

Procedure_Name 14

文本命令中的过程名。A procedure name in a text command. 映射到 DBLITERAL_PROCEDURE_NAME。Maps to DBLITERAL_PROCEDURE_NAME.

Property_Name 26

属性的名称。The name of the property.

Quote_Prefix 15

用在文本命令中的字符,作为将包含特殊字符的标识符引起来的左引号。The character used in a text command as the opening quote for quoting identifiers that contain special characters. 映射到 DBLITERAL_QUOTE_PREFIX。Maps to DBLITERAL_QUOTE_PREFIX.

Quote_Suffix 28

用在文本命令中的字符,作为将包含特殊字符的标识符引起来的右引号。The character used in a text command as the closing quote for quoting identifiers that contain special characters. 用相同字符作为前缀和后缀的 1.x 提供程序可能不返回此文本值,它们在有需要时可将 DBLITERAL 结构的成员设置为 DBLITERAL_INVALID。1.x providers that use the same character as the prefix and suffix may not return this literal value and can set the member of the DBLITERAL structure to DBLITERAL_INVALID if requested. 映射到 DBLITERAL_QUOTE_SUFFIX。Maps to DBLITERAL_QUOTE_SUFFIX.

Schema_Name 16

文本命令中的架构名。A schema name in a text command. 映射到 DBLITERAL_SCHEMA_NAME。Maps to DBLITERAL_SCHEMA_NAME.

Schema_Separator 27

文本命令中将架构名与标识符的其余部分隔开的字符。The character that separates the schema name from the rest of the identifier in a text command. 映射到 DBLITERAL_SCHEMA_SEPARATOR。Maps to DBLITERAL_SCHEMA_SEPARATOR.

Table_Name 17

在文本命令或数据定义接口中使用的表名。A table name used in a text command or in a data-definition interface. 映射到 DBLITERAL_TABLE_NAME。Maps to DBLITERAL_TABLE_NAME.

Text_Command 18

文本命令,例如 SQL 语句。A text command, such as an SQL statement. 映射到 DBLITERAL_TEXT_COMMAND。Maps to DBLITERAL_TEXT_COMMAND.

User_Name 19

文本命令中的用户名。A user name in a text command. 映射到 DBLITERAL_USER_NAME。Maps to DBLITERAL_USER_NAME.

View_Name 20

文本命令中的视图名。A view name in a text command. 映射到 DBLITERAL_VIEW_NAME。Maps to DBLITERAL_VIEW_NAME.

注解

OleDbLiteral枚举返回以下类别的文本信息。The OleDbLiteral enumeration returns the following categories of literal information.

类别Category 返回Returns
文本命令使用的一个或多个特殊字符, 如用于引用标识符的字符。A special character or characters used by text commands, such as the character used to quote identifiers. 一个或多个字符。The character or characters.
文本数据值, 例如 SQL 语句中的字符文本。A literal data value, such as a character literal in an SQL statement. 文本的最大长度 (字符数)、不能用于文本的字符列表以及无法用作文本的第一个字符的字符列表。The maximum length of the literal in characters, a list of the characters that cannot be used in the literal, and a list of the characters that cannot be used as the first character of the literal.
数据库对象的名称, 如列或表。The name of a database object such as a column or table. 名称的最大长度 (字符数)、不能在名称中使用的字符的列表以及无法用作名称的第一个字符的字符列表。The maximum length of the name in characters, a list of the characters that cannot be used in the name, and a list of the characters that cannot be used as the first character of the name.
多维限制列。Multidimensional restriction columns. 返回有关数据源中可用的多维数据集、维度、层次结构、级别和成员的信息的限制值;和被视为文本, 而不是作为搜索模式。Restriction values that return information about cubes, dimensions, hierarchies, levels, and members available from a data source; and are treated as literals instead of as search patterns.

枚举的OleDbLiteral大多数成员映射到在 DBLITERALINFO 结构中返回的 OLE DB DBLITERAL 值之一。Most members of the OleDbLiteral enumeration maps to one of the OLE DB DBLITERAL values that are returned in the DBLITERALINFO structure.

多维限制列是架构对象的成员, 并且映射到 IDBSchemaRowset 接口使用的 OLAP OLE DB。Multidimensional restriction columns are members of schema objects and map to OLE DB for OLAP used by the IDBSchemaRowset interface.

如果指定的文本信息不受支持且不能返回,则生成。NotSupportedExceptionA NotSupportedException is generated if the specified literal information is not supported and cannot be returned.

适用于