How to query columns names

[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

 

[larry]

-----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,

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