>>Please excuse me if this is a repost. I could not find my original post and there are no replies.
>>
>>I would like to write a report that list, table names, field names indexes, format, and coments sort by each of these
>>fields check for consistancy. Before I re-invent the wheel has any one does something like this? If not amy pointers
>>to appropriate dbfs, field names, and set up code would be appreicated.
>
>Please clarify. Are you using SDT? It is in your subject line but you do not refer to it in your question. SDT does provide several options for documenting your database. Have you selected several options and previewed the generated output?
>
>If that is not adequate, you will have to roll your own. I would use ADBObjects() to get an array of tables and views. The easiest way would be to loop through those arrays to open views and tables. Then use AFields() to get the field info. You can use Tag() and TagCount() functions to get Key() expressions for the indexes on each table. DBGetProp() will get you the table or view comment.

Yes I am using SDT and I do use it's build in documentation tool. What I need is additional reports that are will help in
standardizing captions and comments, and help me find similar field names. Some examples are:

1. list comments sorted by table by fieldname ( and/or by fieldname by table)
2. same for comments?
3. list fieldnames and table excluding first 2 or 3 characters (i.e. get all list all fields that end in stkno)

I was hoping some one had already done it. If not I will give it a shot.