Re: Column Name Retrieval

From: Brad Murray <BradMurray_at_SeeSignatureIfThere.com>
Date: 1998/01/08
Message-ID: <MPG.f1f1b63564ae5b19898ad_at_news>#1/1

In article <69385s$md0$1_at_news.nyu.edu>, seco5001_at_quean.cims.nyu.edu said...  

> I am looking for a stored procedure which will return a list of
> the column names and types for a given table. I have searched through
> the documentation to no avail - any help would be great.

Select Column_Name
From Accessible_Columns
Where Table_Name = '[Table Name Here]'
And Owner = '[Schema Here]'

---

 Bradley S. Murray Princeton Computer Consulting (609) 730-9100  BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651 Received on Thu Jan 08 1998 - 00:00:00 CET