The _Tables table is a read-only system table that lists all the tables in the database. Query this table to find out if a table exists.
The _Tables Table has the following column.
| Column | Type | Key | Nullable |
|---|
| Name | Text | Y | N |
Column
- Name
Name of one of the tables.
Remarks
Because the _Tables table is a system table that cannot be modified through SQL queries, you cannot obtain the primary keys with the
MsiDatabaseGetPrimaryKeys function or the
PrimaryKeys property.
Send comments about this topic to Microsoft
Build date: 11/12/2009