Displaying SQL Database Column Names?

[Harry Whitehouse]

How might one go about this. I know how to select data records, but suppose
I wanted to fill a datagrid with the column names in a specified table? How
would I start?

TIA

Harry

[Jonathan Schafer]

I'm sure there is some DataSet or DataTable object that will do this
for you. But since I haven't used any of those, here's a simple query
you can run to get the column info for a table.

select * from syscolumns
where id = object_id('SomeTable')

Jonathan Schafer

On Thu, 7 Aug 2003 17:58:16 -0700, "Harry Whitehouse"
<ha***@envmgr.com> wrote:

How might one go about this. I know how to select data records, but suppose
I wanted to fill a datagrid with the column names in a specified table? How
would I start?

TIA

Harry

[Harry Whitehouse]

Perfect Jonathan! Thanks so much!

Harry

[codewriter]

You can query a database about pretty much anythinhg, tables, datatypes,
etc. How do you thing Toad or Erwin work?

"Harry Whitehouse" <ha***@envmgr.com> wrote in message
news:Or**************@tk2msftngp13.phx.gbl...

How might one go about this. I know how to select data records, but suppose I wanted to fill a datagrid with the column names in a specified table? How would I start?

TIA

Harry