This pulls the records nicely, thanks...
But what would be the variable names of the table attributes?
Thanks
Greg
----- Original Message -----
From: "David L. Penton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 11:46 AM
Subject: RE: get table details
> In Oracle use:
>
> DESC tableName
>
> In SQL Server use:
>
> sp_columns tableName
>
> In Access, either Design the table or write something in VB/VBA using ADO
to
> get the metadata associated with the table.
>
>
> David L. Penton, MCP
> Consultant
> "Mathematics is music for the mind, and Music is Mathematics for the
Soul. -
> J.S. Bach"
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of
> Gregory Price
>
>
> Does anyone know a good way to get the details of a table, like a list of
> the table columns and their maxlengths and datatypes? I would like to do
> this based on the table's title and nothing more...
>
> Any help would be appreciated...
> Thanks
> Greg Price
>
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
