for MS SQL you can do a query to the sysobjects table as follows:
SELECT *
FROM sysobjects
WHERE (xtype = 'U')
HTH
Mark Drew
On Fri, 04 Jun 2004 11:47:49 -0400, Robert Shaw
<[EMAIL PROTECTED]> wrote:
>
> I know I have seen this on the list before but I can't find the exact code.
> Does anyone have the code for querying a database and returning a list of
> tables and/or column info?
>
> TIA,
> Robbie
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
