Hi all,
Some times, this question seems to me as a silly doubt.........anyway, I have decided to ask this ....
Im in a situation where in, I need to write a query to list out all field names/column names against each table based on conditions.
Friends, I have an access *.mdb file which is having almost 120 tables. I need to prepare a report with all table names and the field names of each table where field is of type text. Im just interested in definition of tables and query.
I can go to design view of each table and list out text field names. But, each table will have atleast 20 fields and it is very laborious to list out all field names from almost 120 tables.
To be consice, Im trying something like below.
SELECT [ALL COLUMN_NAMES/FIELD_NAMES] from TABLE_NAME where (data type of FIELD_NAME is Text)
Please suggest a solution or please shout if Im wrong anywhere.