In most databases, there should be a system stored procedure provided to do
this. With Sybase, the system procedure sp_columns <tablename> will return a
resultset with the following info:
table_qualifier,
table_owner,
table_name,
column_name,
data_type,
type_name,
precision,
...etc.
Jeff
-----Original Message-----
From: Steve Buonincontri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 15, 1999 1:22 PM
To: [EMAIL PROTECTED]
Subject: JDBC Question - column headings
Is there a way to get the column types and names from a table with JDBC w/o
selecting a row?
- stevb
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
