Displaying SQL Database Column Names?

  • Thread starter Thread starter Harry Whitehouse
  • Start date Start date
H

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
 
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
 
You can query a database about pretty much anythinhg, tables, datatypes,
etc. How do you thing Toad or Erwin work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve data from a datagrid cell via the column name 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Refresh Datagrid Control? 6
Image not displaying in datagridview column in vb.net 1
OLEDB SELECT Statement 2
Filtering a MS Access Dataset 2
Data Formatting Expression 2
DataGrid --- Showing SQL Columns 2

Back
Top