Get table information of Access Database.

here i will show how you can get table information of access database.

Sql Query:

select * from MSYSObjects

it will show the details of all system table and users table

if you want information of specific table,then you can specify table name in where clause.

ex.

select *

from MSYSObjects

where name='table_name_here'