How to query columns names

  • Thread starter Thread starter Hani Varoqua
  • Start date Start date
H

Hani Varoqua

in SQL Server we can use the following SQL:

Select TABLE_NAEM,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS

to query the columns names of the tables in the SQL SERVER
database.
Do anybody knows how to do this in MS Access environment.
Thanks in advance.

Han
 
-----Original Message-----
in SQL Server we can use the following SQL:

Select TABLE_NAEM,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS

to query the columns names of the tables in the SQL SERVER
database.
Do anybody knows how to do this in MS Access environment.
Thanks in advance.

Han


.
SELECT TH.ServReq, TH.Zone, TT.Type, TR.RName, TH.Loc,
Click to expand...
TH.Sketch, TH.USA, TH.ReqDate, TH.Bid, TH.Contact,
TH.Phone, TH.Emergency, TH.Printed, TH.BidID, TH.BOS,
TD.Line, TD.Mile, TD.Foot, TD.Mat, TD.Dimensions,
TD.Slope, TD.Side, TD.Specific, TD.ComBy, TD.ComDate,
TD.Comments, TD.Return, TD.RDate
 
Back
Top