_Tables Table

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.