Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting information of SQL Tables
Message
 
To
26/04/2001 17:26:38
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00500421
Message ID:
00500424
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform