TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

Information Schema (SQL Server Compact Edition)

Exposes metadata about a database by using INFORMATION_SCHEMA views.

The following table lists Information Schema views that are supported by Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition).

View Contains information about

COLUMNS

Columns accessible to the current user in the current database.

INDEXES

Indexes in the current database.

KEY_COLUMN_USAGE

Keys in the current database.

PROVIDER_TYPES

Data types supported in SQL Server Compact Edition.

TABLES

Tables accessible to the current user in the current database.

TABLE_CONSTRAINTS

Table constraints in the current database.

REFERENTIAL_CONSTRAINTS

Foreign constraint in the current database

To retrieve data from these views, use the fully qualified name INFORMATION_SCHEMA:

SELECT * FROM INFORMATION_SCHEMA.TABLES
Show:
© 2016 Microsoft