dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Exploring Table Information

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date