Question:
How do I interrogate tables randomly and print out their structures, components, sizes, and indexes? This ability would be useful in allowing me to check how I have created tables, what indexes have been set, what the string sizes are, and so forth, without needing to check through all the code or using the field editor.
Answer:
Well, you have either the Database Explorer or the Database Desktop for those types of operations, but if you want to code for that stuff yourself, I suggest you look into the TSession object in the help file. For a good discussion of creating a “table explorer,” one of the best treatments I’ve seen so far is in Charlie Calvert’s Delphi 4 Unleashed. He builds an explorer piece by piece, grabbing all the table information that you’re looking for.