The following schema rowsets are used by the OLE DB Provider for Microsoft SQL Server Compact 3.5 to reveal functionality specific to SQL Server Compact 3.5.
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 3.5 only supports TABLE_NAME and COLUMN_NAME restriction columns. |
DBSCHEMA_INDEXES |
The INDEXES rowset identifies the indexes defined in the database. SQL Server Compact 3.5 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 3.5 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 3.5 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 3.5 only supports CONSTRAINT_NAME and TABLE_NAME restriction columns. |
DBSCHEMA_TABLES |
The TABLES rowset identifies the tables defined in the database. SQL Server Compact 3.5 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 3.5 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 3.5 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 3.5:
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.
All provider-specific columns listed earlier in this topic are of type DBTYPE_I8. In earlier versions of SQL Server Compact 3.5, they were of type DBTYPE_I4 |