SQL

[chs]

Hi all:

Anyone has any ideas for how to use the SQL select command to
select the name of the columns of a table?
I found some select command for the first row which is not
the one
I needed.

cheers,
chs

 

[Aaron Bertrand - MVP]

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table name'

 

[chs]

But are there any SQL commands for Access, instead of SQL server?

 

[Chris Barber]

Go and read a short tutorial on 'basic' SQL and then repost any specific
questions that you have.
http://www.w3schools.com/sql/default.asp

NB: You want:

SELECT [FieldName]
FROM TableName

*** OPTIONAL WHERE CLAUSE ***
WHERE [Fieldname] = 'SomeValue'

eg. SELECT [UserID] FROM Users WHERE [Username] = 'Gerald87'

Would return a recordset with one field [UserID] with any records that have
[Username] equal to 'Gerald87'.

This sort of basic SQL statement can be used against any data source.

 

[chs]

Hi Mr. Chris Barber:
1) Isn't my question specified enough? I am looking for SQL command to
retrieve Access table's column name.(Please refer back to my previous post)
2) Just simple SQL commands...not the ADOX or recordset methods posted on
http://www.aspfaq.com/2177.
Thanks!

 

[chs]

Hi Mr. Chris Barber:
1) Isn't my question specified enough? I am looking for SQL command to
retrieve Access table's column name. (please refer back to first post)
2) Just simple SQL commands...not the ADOX or recordset methods posted on
http://www.aspfaq.com/2177.
Thanks!

 

[chs]

How about just simple SQL commands...not the ADOX or recordset methods .
Thanks!

 

[Bob Barrows]

I would think you would have gotten the idea by now that there aren't any!

Access does not maintain a table containing the column names of all the
user-defined tables. This is one of the reasons ADOX was created.

You might want to try the OpenSchema method as well.
http://msdn.microsoft.com/library/en-us/ado270/htm/mdamth03_4.asp

Bob Barrows