Export (0) Print
Expand All
Expand Minimize

Information Schema (SQL Server Compact)

Exposes metadata about a database by using INFORMATION_SCHEMA views.

The following table lists Information Schema views that are supported by SQL Server Compact.

View

Contains information about

COLUMNS

Columns accessed 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.

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 the views listed above, use the fully qualified name INFORMATION_SCHEMA. This example retrieves information about the tables in the database.

SELECT * FROM INFORMATION_SCHEMA.TABLES
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft