Nóta
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað aðskrá þig inn eða breyta skráasöfnum.
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað að breyta skráasöfnum.
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