Notiz
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Iech unzemellen oder Verzeechnesser ze änneren.
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Verzeechnesser ze änneren.
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