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 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. I use a system DSN here, but ' you can use whatever method you wish Conn. While Not Rs. MoveNext Loop ' Close and destroy the recordset and connection objects Rs.