Export (0) Print
Expand All

OLE DB Schema Rowsets (SQL Server Compact Edition)

The following schema rowsets are used by the OLE DB Provider for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) to reveal functionality specific to SQL Server Compact Edition.

OLE DB schema name Description and GUID (if needed)

DBSCHEMA_COLUMNS

The COLUMNS rowset identifies the columns of tables defined in the database. SQL Server Compact Edition only supports TABLE_NAME and COLUMN_NAME restriction columns.

DBSCHEMA_INDEXES

The INDEXES rowset identifies the indexes defined in the database. SQL Server Compact Edition only supports INDEX_NAME and TABLE_NAME restriction columns.

DBSCHEMA_KEY_COLUMN_USAGE

The KEY_COLUMN_USAGE rowset identifies the columns defined in the database. SQL Server Compact Edition only supports CONSTRAINT_NAME and TABLE_NAME restriction columns.

DBSCHEMA_PROVIDER_TYPES

The PROVIDER_TYPES rowset identifies the (base) data types supported by the data provider. SQL Server Compact Edition only supports the DATA_TYPE restriction column.

DBSCHEMA_TABLE_CONSTRAINTS

The TABLE_CONSTRAINTS rowset identifies the table constraints defined in the database. SQL Server Compact Edition only supports CONSTRAINT_NAME and TABLE_NAME restriction columns.

DBSCHEMA_TABLES

The TABLES rowset identifies the tables defined in the database. SQL Server Compact Edition only supports TABLE_NAME and TABLE_TYPE restriction columns.

DBSCHEMA_TABLES_INFO

The TABLES_INFO rowset identifies the tables defined in the database. SQL Server Compact Edition only supports TABLE_NAME and TABLE_TYPE restriction columns.

DBSCHEMA_REFERENTIAL_CONSTRAINTS

The REFERENTIAL_CONSTRAINTS rowset identifies the referential constraints defined in the database. SQL Server Compact Edition only supports the CONSTRAINT_NAME restriction column; it does not support DBSCHEMA_FOREIGN_KEYS. However, you can obtain the same information by performing a JOIN on DBSCHEMA_KEY_COUMN_USAGE and DBSCHEMA_REFERENTIAL_CONSTRAINTS.

The DBSCHEMA_COLUMNS rowset returns the following columns that are specific to SQL Server Compact Edition:

  • AUTOINC_MIN
    The minimum value of an auto increment column.
  • AUTOINC_MAX
    The maximum value of an auto increment column.
  • AUTOINC_NEXT
    The next value of an auto increment column.
  • AUTOINC_SEED
    The starting value of an auto increment column.
  • AUTOINC_INCREMENT
    The increment value of an auto increment column.
Note:
All provider-specific columns listed earlier in this topic are of type DBTYPE_I8. In earlier versions of SQL Server Compact Edition, they were of type DBTYPE_I4

Community Additions

ADD
Show:
© 2015 Microsoft