Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Relational Databases
Expertise: Beginner
Jan 27, 1999

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date