Also sp_help tablename (SQL Server) does the same thing, though it's
probably overkill.
Also, Dave, when you presented last month, I saw you use a nifty little
stored procedure that seemed to show a lot of info for the database you
were using.. Sp_describe or something like that. Is that something
canned in SQL Server, or something that you wrote?
---
Billy Cravens
HR Systems, Sabre
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of David L. Penton
Sent: Wednesday, June 06, 2001 11:47 AM
To: [EMAIL PROTECTED]
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
