OLE DB Schema Rowsets (SQL Server Compact)
The following schema rowsets are used by the OLE DB Provider for Microsoft SQL Server Compact 4.0 to reveal functionality specific to SQL Server Compact 4.0.
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 4.0 only supports TABLE_NAME and COLUMN_NAME restriction columns. |
DBSCHEMA_INDEXES |
The INDEXES rowset identifies the indexes defined in the database. SQL Server Compact 4.0 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 4.0 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 4.0 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 4.0 only supports CONSTRAINT_NAME and TABLE_NAME restriction columns. |
DBSCHEMA_TABLES |
The TABLES rowset identifies the tables defined in the database. SQL Server Compact 4.0 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 4.0 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 4.0 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. |
Provider-Specific Schema Rowset Columns
The DBSCHEMA_COLUMNS rowset returns the following columns that are specific to SQL Server Compact 4.0:
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 4.0, they were of type DBTYPE_I4