Exploring Table Information

Exploring Table Information

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.

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.


Share the Post: