[AccessD] Indexes

Hi Martin
Here's code to get the indexes of a table

Dim idx As Index

'Then, assuming you have your TableDef in tbl

For Each idx In tbl.Indexes
'You can get at such things as
idx.Foreign
idx.Name
idx.Unique
idx.Primary
Then you can get at the idx.Fields collection and enumerate the fields of
the   index. I guess you could then enumerate the Properties collection of
each Field and find out each field's data type and, probably, length
Next


--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] Indexes
Date: 02/06/06 12:31

I want to loop over all tables in a database and get the Index name and
length. I can get the tables ok but cant seem to get the index length.

Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477








--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2