Export (0) Print
Expand All

Information Schema

SQL Server 2000

Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) exposes meta data about the current database through the following INFORMATION_SCHEMA views.

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 CE.
TABLES Tables accessible to the current user in the current database.
TABLE_CONSTRAINTS Table constraints in the current database.

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

SELECT * FROM INFORMATION_SCHEMA.TABLES

Show:
© 2014 Microsoft