It also contains information about how the data is stored internally, as well as how it is stored physically on the storage device. Database schema is primary to any database, as all requests to any data go through it. Without a schema, it would be impossible to connect to any database. With that said, let's see how we can extract the list of tables from any database. The preceding picture shows an Access 97 database with three tables.
Access also maintains a database schema, like any other database.
Our goal is to list these tables in our ASP code. The following ASP code depicts how we will extract the table names from the above database. While the above database is not a part of this tutorial, you can use almost any Access database to try the following code. Before we proceed, I will tell you a little bit about the include file - adovbs.inc. This file contains all the constants that are defined in the ADO library.