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" <sc****@pd.jaring.my> wrote in message
news:bf**********@news5.jaring.my...

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

[chs]

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

"Randy R" <rvrahbarAThotmail.com> wrote in message
news:ug**************@TK2MSFTNGP12.phx.gbl...

Anyone has any ideas for how to use the SQL select command

to

select the name of the columns of a table?

This may help you...
http://www.aspfaq.com/2177

[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" <sc****@pd.jaring.my> wrote in message
news:bf**********@news5.jaring.my...

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

"Randy R" <rvrahbarAThotmail.com> wrote in message
news:ug**************@TK2MSFTNGP12.phx.gbl...

Anyone has any ideas for how to use the SQL select

command to

select the name of the columns of a table?

This may help you...
http://www.aspfaq.com/2177

[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!
"Chris Barber" <ch***@blue-canoe.co.uk.NOSPAM> wrote in message
news:ew**************@TK2MSFTNGP10.phx.gbl...

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 first post)
2) Just simple SQL commands...not the ADOX or recordset methods posted on
http://www.aspfaq.com/2177.
Thanks!


"Chris Barber" <ch***@blue-canoe.co.uk.NOSPAM> wrote in message
news:ew**************@TK2MSFTNGP10.phx.gbl...

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

[chs]

How about just simple SQL commands...not the ADOX or recordset methods .
Thanks!
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:ue**************@TK2MSFTNGP11.phx.gbl...

chs wrote:

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

"Randy R" <rvrahbarAThotmail.com> wrote in message
news:ug**************@TK2MSFTNGP12.phx.gbl...

Anyone has any ideas for how to use the SQL select
command to select the name of the columns of a table?

This may help you...
http://www.aspfaq.com/2177

Did you read the entire article? It does describe some Access solutions.

I would prefer to use ADOX as in the aspfaq article, but the Recordset
solution offered (add "Where 1=2" to the SQL statement shown to prevent

all the data in the table from being retrieved) should work well ...

Bob Barrows

[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...mdamth03_4.asp

Bob Barrows

chs wrote:

How about just simple SQL commands...not the ADOX or recordset
methods . Thanks!
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:ue**************@TK2MSFTNGP11.phx.gbl...

chs wrote:

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

"Randy R" <rvrahbarAThotmail.com> wrote in message
news:ug**************@TK2MSFTNGP12.phx.gbl...
> Anyone has any ideas for how to use the SQL select
> command to select the name of the columns of a table?

This may help you...
http://www.aspfaq.com/2177

Did you read the entire article? It does describe some Access
solutions.

I would prefer to use ADOX as in the aspfaq article, but the
Recordset solution offered (add "Where 1=2" to the SQL statement
shown to prevent all the data in the table from being retrieved)
should work well ...

Bob Barrows