You are here: Data Services > Oledb Component > Schema Rowsets > COLUMNS Rowset

COLUMNS Rowset

The COLUMNS rowset identifies the columns of tables (including views) defined in the application definition (catalog) that are accessible to a given user.

GUID: DBSCHEMA_COLUMNS

Number of restriction columns: 4

Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

Default sort order: TABLE_NAME

Scantron OLE DB Provider implementation of Columns Rowset is as follows:

Column name	Type indicator	Description
TABLE_CATALOG	DBTYPE_WSTR	NULL
TABLE_SCHEMA	DBTYPE_WSTR	NULL
TABLE_NAME	DBTYPE_WSTR	Document Definition Name
COLUMN_NAME	DBTYPE_WSTR	As in Output Record Definition for that document
COLUMN_GUID	DBTYPE_GUID	NULL
COLUMN_PROPID	DBTYPE_UI4	NULL
ORDINAL_POSITION	DBTYPE_UI4	One-based number representing the order in the output record.
COLUMN_HASDEFAULT	DBTYPE_BOOL	VARIANT_TRUE—The column has a default value. VARIANT_FALSE—The column does not have a default value, or it is unknown whether the column has a default value.
COLUMN_DEFAULT	DBTYPE_WSTR	NULL
COLUMN_FLAGS	DBTYPE_UI4	A bitmask that describes column characteristics. The DBCOLUMNFLAGS enumerated type specifies the bits in the bitmask. For information about DBCOLUMNFLAGS, see "IColumnsInfo::GetColumnInfo" in the MSDN reference. This column cannot contain a NULL value. If COLUMN_NAME refers to a column in a table or view that is updatable, one of either DBCOLUMNFLAGS_WRITE or DBCOLUMNFLAGS_WRITEUNKNOWN should be set. For more information about these flags, see "DBCOLUMNFLAGS Enumerated Type" in the MSDN reference.
IS_NULLABLE	DBTYPE_BOOL	VARIANT_TRUE—The column might be nullable. VARIANT_FALSE—The column is known not to be nullable.
DATA_TYPE	DBTYPE_UI2	Type of the data contained in the column. One of the DBTYPE constants defined by OLE DB.
TYPE_GUID	DBTYPE_GUID	NULL
CHARACTER_MAXIMUM_LENGTH	DBTYPE_UI4	The maximum possible length of a value in the column. For character, binary, or bit columns, this is one of the following: The maximum length of the column in characters, bytes, or bits, respectively, if one is defined. For example, a CHAR(5) column in an SQL table has a maximum length of 5. The maximum length of the data type in characters, bytes, or bits, respectively, if the column does not have a defined length. Zero (0) if neither the column nor the data type has a defined maximum length. NULL for all other types of columns.
CHARACTER_OCTET_LENGTH	DBTYPE_UI4	NULL
NUMERIC_PRECISION	DBTYPE_UI2	NULL
NUMERIC_SCALE	DBTYPE_I2	NULL
DATETIME_PRECISION	DBTYPE_UI4	NULL
CHARACTER_SET_CATALOG	DBTYPE_WSTR	NULL
CHARACTER_SET_SCHEMA	DBTYPE_WSTR	NULL
CHARACTER_SET_NAME	DBTYPE_WSTR	NULL
COLLATION_CATALOG	DBTYPE_WSTR	NULL
COLLATION_SCHEMA	DBTYPE_WSTR	NULL
COLLATION_NAME	DBTYPE_WSTR	NULL
DOMAIN_CATALOG	DBTYPE_WSTR	NULL
DOMAIN_SCHEMA	DBTYPE_WSTR	NULL
DOMAIN_NAME	DBTYPE_WSTR	NULL
DESCRIPTION	DBTYPE_WSTR	Field data type from the ScanTools application, (example Alphanumeric, Numeric, 1-digit, 2-digit, Date)
IS_ARCHIVE_INDEX	DBTYPE_BOOL	VARIANT_TRUE—The column is an archive index. VARIANT_FALSE—The column is not an archive index.

See Using Restrictions on Schema Rowsets for information about Filtering rows of COLUMNS Rowset.

See Help on Help for additional information on using this help file.

See Scantron Technical Support for additional information on technical support and training options.

See the ScanTools Suite System Requirements for further details on hardware and software requirements.

ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:

ScanTools Plus Scanning Module WebHelp

(includes Real-Time Character Recognition utilizing NestorReader Help)
ScanTools Plus Application Designer Module WebHelp

(includes Real-Time Character Recognition utilizing NestorReader Help)
ScanTools Plus Download Utility WebHelp
ScanTools Plus User Exits WebHelp
ScanTools Plus Legacy Reference Information WebHelp

(a previous version of ScanTools Plus Help that may help power users)
ScanTools Plus Link SDK WebHelp
(API Help for developers)

Scantron Corporation

Customer Service (forms, products, and services):

1-800-SCANTRON (722-6876)

www.scantron.com

Technical Support:

1-800-445-3141

support@scantron.com

Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation.

LINKS TO THIRD PARTY SITES

This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators.