How do I enum the columns of a table? 
Author Message
 How do I enum the columns of a table?

Very simple question ,

What is the best way to enumerate over all of the columns of a table?  I
used the GetTableNames method to get table names, now how do I get the
column names  and datatypes for a selected table?

RM



Tue, 19 Oct 1999 03:00:00 GMT
 How do I enum the columns of a table?

Query the FieldDef of the table

R/S

Will Wilson
CWILSON277



Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. connect enum or boolean columns to checkboxes /radiobuttons with oracle

2. [Q] Status of ENUM column type.

3. Enum Catalog Tables finds Queries

4. inserting multible columns from one table into a single column in another table

5. Selecting the first 6 columns of a table by column order/ column id

6. spaces in column names, when doing sql calls in java

7. SQL7 db wont show columns when doing a query using enterprise manager

8. Doing a Like Comparison on two columns

9. Suppressing Column Headings when doing a select * from ...

10. Doing stuff with the timestamp column ...

11. spaces in column names, when doing sql calls in java

12. ADO thinks DBMS is done, but DBMS ain't done


 
Powered by phpBB® Forum Software