Information Schema (SQL Server Compact Edition)

Exposes metadata about a database by using INFORMATION_SCHEMA views.

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