how check tables and index of a database

[ron9999]

I try to check the tables and index of my app.
How I thought it could go.

Open the database and check how many tables there
This, I guess will go with DBGETPORP() but I don’t know how
here I need help please.
I don’t know how to write a loop to get all tables out of the databases.

If I have all tables in a array I compare it with a asci file where the tables written.
If a table is missing I create it
Then I check every tables field
and last I check every index of each table
every thing I know how to do except to get the tables of the databases
appreciate every help
Tia
Ron

 

[Stefan5627]

You can open the database as a table and look for the tables there

use database.dbc again noupdate alias test
go top
scan for objecttype = "Table"

   lcTablename = alltrim(test.objectname)
   
   *your code here

endscan

 

[ron9999]

thank you stefan it works
ron

 

[TamarGranor]

Check out the ADBOJECTS() function. It tells you all about a database.

Tamar

 

[ron9999]

thank you Tamar
ron