Link to home
Start Free TrialLog in
Avatar of RD11
RD11

asked on

SQL query select statement to get table headers only

Hi,

I am looking for a sql query select statement to get table headers only.  
Any idea?

Thank you,
RD11
SOLUTION
Avatar of knightEknight
knightEknight
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RD11
RD11

ASKER

I just want to get the column headers in a table.
Avatar of markterry
markterry
Select column_Name  from information_Schema.columns where table_name = 'TableName'
Avatar of markterry
markterry
Just replace the last 'tablename' with a real table name
Avatar of RD11
RD11

ASKER

Does this work in MS Access, I could not run it.  I got an error message that it could not find the schema file.
ASKER CERTIFIED SOLUTION
Avatar of markterry
markterry
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RD11
RD11

ASKER

All G:):)D Thank you