Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting information of SQL Tables
Message
 
À
26/04/2001 17:26:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00500421
Message ID:
00500424
Vues:
12
>Hi, everybody!
>
>Is there someway to get information of SQL Tables? For example: I need to, given a SQL table, identifie every fields, captions, datatypes, width, etc... as we easily do on VFP...
>
>Does anybody can tell me how could I do that?
>
>Thanks in advance.

There is a sysobjects table and syscolumns table that contains information about the tables in the database. You should be able to look there and get what you want.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform