The PRIMARY_KEYS rowset identifies the primary key columns defined in the catalog by a given user. This schema rowset is built upon an SQL-92 schema view as a convenience to the non-SQL programmer and, if supported, must be synchronized with the related SQL-92 view (CONSTRAINT_COLUMN_USAGE).
Scantron OLE DB Provider implements the Primary_Keys rowset over the [Serial Number] column within the NCS Header. This supports the OleDbCommandBuilder class in the .Net framework as well as the client cursor engine in MDAC (recall ADODB.CursorTypeEnum.adUseClient). The Data Adapter Configuration Wizard in Visual Studio.Net consumes this rowset.
This schema rowset provides information that is of use to SQL query builders. This schema rowset is typically invoked by the ADO Client Cursor Engine (CCE) and the .Net framework System.Data.OleDb.OleDbCommandBuilder.
GUID: DBSCHEMA_PRIMARY_KEYS
Number of restriction columns: 3
Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
Default sort order: TABLE_NAME
Scantron.Oledb 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 |
Table name |
|
COLUMN_NAME |
DBTYPE_WSTR |
Primary key column name |
|
COLUMN_GUID |
DBTYPE_GUID |
NULL |
|
COLUMN_PROPID |
DBTYPE_UI4 |
NULL |
|
ORDINAL |
DBTYPE_UI4 |
One-based order of the column names (and GUIDs and property IDs) in the key |
|
PK_NAME |
DBTYPE_WSTR |
Primary key name. "PK_" prefix added to TABLE_NAME |
|
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:
|
Scantron Corporation
Customer Service (forms, products, and services): 1-800-SCANTRON (722-6876) Technical Support: 1-800-445-3141 |
|
|
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. |
||