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
