Return Table Field Names

[Strange_Will]

So pretty simple, I want to get all of the field names in the database in the most efficient way... any ideas? Like SQL statement wise?

I guess I could do a select * from table WHERE 0=1 then use a for next for each item in DBRS.FIELDS to get it... any better ways?

 

[TechGnome]

Depends.... what database are you using... Access? SQL Server? Oracle? Something else?

-tg

 

[Strange_Will]

Depends.... what database are you using... Access? SQL Server? Oracle? Something else?

-tg

MySQL

Grr limit

 

[jmcilhinney]

If you're using an OleDbConnection then you can probably call GetOleDbSchemaTable, although I've never used it myself.