Use the INFORMATION_SCHEMA views on the system tables - they've got a heap of information.
There's also the FN_LISTEXTENDEDPROPERTY function to retrieve extended properties from SQL server objects
Cheers,
Andrew
>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.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.